• 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.

Autofill a column from cell A3 from multiple sheets

Matt_Straya

Matt_Straya

Member
Hi,
I am trying to gather all the info from 180 sheets into one master sheet. I can do it by doing this:
=Form1!A$3
The dragging it across to fill all the columns with the right data. However, I need to copy it down to get the next sheet with:
=Form2!A$3
and so on up to Form180.

Is there a simple way to do this? I have tried a number of different formulas that just don't work.
I would really appreciate the assistance.
 
Thanks Bosco!
I don't think it changes to the next sheet as I copy it down. the sheets are named "Form1" "Form2" etc up to 180

Also, I need to copy it across once I have gone down. So I can get it to reference colomn B ok but it wont flick over to B3:
=INDIRECT("Form"&COLUMNS(B:B)&"!A$3")
need column B to say:
=INDIRECT("Form"&COLUMNS(B:B)&"!B$3")

I need to copy it across to coloumn ACS .. (yep..773 columns)

Regards
Matt
 
Last edited:
Ok - I have used this:
=INDIRECT($A3 &"!BZ$3")
Which works well downwards but not across. Toys are currently being ejected from ones cot.
And this one works going across but not down:
=Form1!BZ$3

I have created a list of the sheets in column A
 
Last edited:
You must log in or register to reply here.
Back
Top