Using a macro to copy from one workbook to another

Hi

I have a spreadsheet with multiple worksheets in a spreadsheet which has been distributed and filled out by others.

I would to be able to:
-open each returned spreadsheet (by browsing and selecting the file)
-click a macro and have the macro select information from a range for each worksheet and have that information copied into the relevant worksheet in a master spreadsheet. I.e workbook1 to workbook1, workbook2 to workbook2
-during the copying process the information should be filled in the next empty row in the master spreadsheet

Thanks,

That's not difficult but where is the data to copy & how is it arranged? A sample workbook would help.

Try this code, add it to a Standard module

Please Login or Register  to view this content.

Wow this code is pretty cool.

Does the copy happen between the exact sheet numbers rather than sheet names?

Could you explain a little more about the code around the range to copy and the destination range.

I.e what does cells(2,1) mean etc.

Also
- can you add a code to specific certain worksheets not to copy?
- as I have named ranges, everytime I open the code, it ask me whether I would like to replace. I would simply be able to ignore and go with yes all the time

Thanks,

Cells(2,1) is A2, ie row 2 , column 1. This amendment will allow you to excllude specific sheets

Please Login or Register  to view this content.

It is already dynamic.

Originally Posted by steve_c

Hi

How would you make this component of the code dynamic? I.e I want to copy and cut each range which would be different for each workbook rather

Cells(.Rows.Count, 3).End(xlUp))

You may b e able to use CurrentRegion or UsedRange

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.