Pulling data from multiple cell's in a series of spreadsheets
Closed
Excelray
rizvisa1
- Posts
- 2
- Registration date
- Friday March 1, 2013
- Status
- Member
- Last seen
- March 1, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Pulling data from multiple cell's in a series of spreadsheets
- How to pull data from one cell to another sheet in excel - Guide
- Data validation for multiple cells - Guide
- How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
- How to fill multiple Excel sheets from master sheet - Guide
- How to pull data from a master sheet in excel - Guide
2 replies
rizvisa1
Mar 1, 2013 at 07:00 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 1, 2013 at 07:00 AM
I for one cannot claim, I understood you 100%. This is what I am getting
1. You have multiple sheets
2. From each sheet, you only want to copy some specific cells and paste them as rows in a new sheets
3. The copy process is like this, there are groups of cells that you want to copy from each sheet. Once that group is done, you have another group of cells that you would again copy from each sheet.
1. You have multiple sheets
2. From each sheet, you only want to copy some specific cells and paste them as rows in a new sheets
3. The copy process is like this, there are groups of cells that you want to copy from each sheet. Once that group is done, you have another group of cells that you would again copy from each sheet.
Excelray
Mar 1, 2013 at 02:16 PM
- Posts
- 2
- Registration date
- Friday March 1, 2013
- Status
- Member
- Last seen
- March 1, 2013
Mar 1, 2013 at 02:16 PM
Yes that right, and I have tried using the function where you just point to a cell in another sheet, but when I copy and past that in to another cell and change the function to point to the next sheet Excel asks to look for the next sheet every time. I just need a way to automate this, or reduce the workload down some/a lot.
rizvisa1
Mar 2, 2013 at 11:41 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 2, 2013 at 11:41 AM
Things are not clear to me
1. You have group cells to copy. So lets say one of this group consist of C1,D1,C2,D2 (in cell c1,d1,c2,d2 respectively)
How they would be copied ?
as
C1 D1
C2 D2
or
C1
D1
C2
D2
Also how one can say what are those groups ?
1. You have group cells to copy. So lets say one of this group consist of C1,D1,C2,D2 (in cell c1,d1,c2,d2 respectively)
How they would be copied ?
as
C1 D1
C2 D2
or
C1
D1
C2
D2
Also how one can say what are those groups ?