• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy the top row of multiple sheets to sheet1

Matt_Straya

Matt_Straya

Member
Hi, I have had a brain fade and cant, simply copy the top row of multiple sheets to sheet1. Its easy using this =Sheet2!1:1 in A1 in sheet1 etc but there are over a 1000 sheets and it would just take to long to do it all manually. Is there a way to simply copy the formula to do this?
=sheet2!1:1
=sheet3!1:1
=sheet4!1:1 and so on
 
pecoflyer said:
@p45cal Didn't know that VSTACK accepted 3D-References. Good to know. Would you have a link to a complete set of these functions, I can't seem to find an updated one. Thx
Click to expand...

Create a 3-D reference to the same cell range on multiple worksheets - Microsoft Support

Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.
support.microsoft.com support.microsoft.com

about half way down:

Create a 3-D reference​

  1. Click the cell where you want to enter the function.
  2. Type = (equal sign), enter the name of the function, and then type an opening parenthesis.

    You can use the following functions in a 3-D reference:
 
Thanks. I know how it works. VSTACK/HSTACK seem to be the only ones added to the older functions. Good to know
 
You must log in or register to reply here.
Back
Top