appending worksheet records into 1 worksheet

J

JASelep

I've numerous spreadsheets (~680) with multiple worksheets, (worksheets
identically formatted and named)

I wish to merge/append the records of coinciding worksheets into a master
prior to export to Access. What is best way to automate a such a process?
no records will be combined just appended to one another.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

appending worksheet records 0
Worksheet + 1 1
Macro to copy rows into worksheets 4
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Combining Multilple Worksheets Into One 6
Random selections 2
Combine multiple worksheets in one Workbook into one big worksheet 6
How do I combine multiple worksheets into one worksheet? 1

Top