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
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??
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:
- Data transfer from all sheets to 1
- Tentacle locker 1 - Download - Adult games
- Free fire transfer - Guide
- Fnaf 1 download pc - Download - Horror
- Igi 1 download - Download - Shooters
- Transfer data from one excel worksheet to another automatically - Guide
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
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.
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.