Previous Topic Next Topic

Combine Excel Sheets from folder into 1 book

Closed
bex10000 Posts 1 Registration date Wednesday November 18, 2009 Status Member Last seen November 19, 2009 - Nov 19, 2009 at 11:00 AM
 Blocked Profile - Nov 22, 2009 at 03:51 AM
Hi Ya,

I have a number of workbooks in a folder which I would like to combine certain cells of them into another spreadsheet. The cells I need from the work books are in different sheets but are the same for every work book. I then need to show the data in the new spreadsheet in a table format - can anyone help??

Many Thanks

Rebecca

PS I have Excel 2007
Related:

1 response

Answer 1 / 1
Blocked Profile
Nov 22, 2009 at 03:51 AM
Dear Sir,

Please follow the below instructions that will help you in combining

the different spreadsheets and completing the task:

https://ccm.net/faq/4938-how-to-compare-two-excel-sheets-and-combine-unique-data

Thanks in advance.
1