Data transfer from all sheets to 1

Closed
amar - Jun 15, 2016 at 11:07 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jun 16, 2016 at 12:20 AM
Hello,
please help me..
i am trying to make a production report & for that i have to copy data from numerous sheets to 1 sheet & then calculate.
suppose the data to be transferred is from sheet 1 A1, so the formula would be ='sheet1'!A1 but to copy data from all sheets from cell A1 what i have to do??


Related:

1 response

vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Jun 16, 2016 at 12:20 AM
Hello Amar,

If you only need the data from cell A1 from each sheet, then you can use the same formula but in each consecutive row. So, in row 2 (in whichever column), you can use =Sheet2!A1, in row 3 use =Sheet3!A1 etc...........

I hope that this helps.

Cheerio,
vcoolio.
0