merging multiple files/sheets into one

  • Thread starter Stephen.Schoenberger
  • Start date
S

Stephen.Schoenberger

I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each
file has the same sheet in it but with different data. Do not have to
worry about data overwriting. I have seen something like this before
but can not remember how to do it with VBA.

Thanks!
 

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

merging multple columns into one column (dynamically) 2
Open a word mail-merge document from Excel VBA 1
Help with copying a sheet from One workbook to another workbook 1
Save record Into master sheet! 1
CONSOLIDATE DATA FROM MULTIPLE SHEETS IN ONE 1
copy sheets from many files into 1 1
hide multiple worksheets based on a formula value in one cell 1
Macro to generate powerpoint slides 43

Top