pulling data from multiple cell's in a series of spreadsheetsClosed

Question

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. 


Configuration: Windows 7 / Chrome 25.0.1364.97

rizvisa1 · Answer

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.

Excelray · Answer

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.

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

2 replies

Subscribe To Our Newsletter!