Previous Topic Next Topic

Pulling data from multiple cell's in a series of spreadsheets

Closed
Excelray Posts 2 Registration date Friday March 1, 2013 Status Member Last seen March 1, 2013 - Mar 1, 2013 at 02:00 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 2, 2013 at 11:41 AM
Hello,

I have already done some searches for help on this but I don't think I am coming up with the right way to say it to search for it probably. So if you know of another thread please point me there.

Now on to what I am trying to do. I have series of spreadsheets where I need to pull data from multiple cell's then put that data in to another spreadsheet in a row for each sheets data.

So something like this.

sheets are named "#1000_name.xls - #1130_name.xls" and I need data from cell's C2,D30,E5*E6 then I need it to go in to another sheet where they would be in a row
like so C2-C10 and so on for each sheet.

I have had to do this manually and I am getting tired of all of the copying and pasting, it is like 5 copy and pasts per sheet and there is over 130 of them which it taking way to long.

I hope I have explained this well, Thank you all for any help.


2 replies

Answer 1 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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.
0
Answer 2 / 2
Excelray 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.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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 ?
0