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

[Closed]
Report
Posts
2
Registration date
Friday March 1, 2013
Status
Member
Last seen
March 1, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.
Posts
2
Registration date
Friday March 1, 2013
Status
Member
Last seen
March 1, 2013

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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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 ?