{"id":14610,"date":"2021-12-15T11:51:38","date_gmt":"2021-12-15T11:51:38","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=14610"},"modified":"2021-12-15T11:52:14","modified_gmt":"2021-12-15T11:52:14","slug":"excel-reference-2nd-sheet-without-the-name","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-reference-2nd-sheet-without-the-name\/13579.html","title":{"rendered":"Excel Reference 2nd Sheet Without The Name"},"content":{"rendered":"<p>What I need to know is how to reference the second sheet in a (2003, .xls) workbook when using an Excel Formula without using the sheets name.<\/p>\n<p>I need be able to write the following formula<br \/>\n=Average(&#8216;Sheet 2&#8217;!A1:C3)<br \/>\nExcept The Sheet name will not be &#8220;Sheet 2&#8221; but will change<\/p>\n<p>I know you can do this when creating a Macro. You can refer to the second sheet of any document with by using Sheets(2) no matter what the sheet name is.<\/p>\n<p>Thanks<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":5},"question-category":[53],"question_tags":[],"class_list":["post-14610","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/14610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=14610"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=14610"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=14610"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=14610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}