COMBINDING EXCEL SPREADSHEETS

[zupko]

I have a number of spreadsheets all with the exact same fields. Does anyone have a quick way to do this instead of doing a copy and paste?

 

[MichaelRed]

This is WAY off topic for Ms. Accrss REPORTS. If you are capable of some coding in VBA, Ms. Access can create a table with all of the spreadsheest's data. It can also be done in Excel, but like the Tic-Tac ad says - "I wouldn't recommend it". If you have some knowledge of VBA, post his in a more appropitate forum - including some details and you should get an answer.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[plang99]

At bottom of table in first cell LINK to other Excel file and copy link to a range equal to the Linked File. Then select new range and Copy/Past Special/Values. This simulates the Way File Combine worked in Lotus 123 or use Lotus 123 to do it.