Exel master workbook

After running the macro the 1st time, if you make changes to the individual workbooks and want to run the macro again, do you want the contents of the master file to be cleared and fresh data input?

Will the master file already have data in it or should the macro start with a new workbook each time you run the macro?

Try this code - change the bold areas as required -

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

Hmm thats the first time i have seen that error. Is your sheet named Sheet2 in your file from which the data needs to be copied?

Yes. Ensure it matches exactly with your sheet name with regards to spelling and case.

That code is fine as long as there is no dot (.) after row. Just check that and try the code again.

No the formula should not affect the macro.

Can you attach a sample file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

So you have multiple files like this one which need to have their DATA tab consolidated into a new workbook right?

I tested the code given in post 4 and except for changing

Please Login or Register  to view this content.

, i didnt make any other changes. It worked fine at my end.

Try moving that line - lastrow = ...etc above the "With Sourcedata" line. I ran it with this option and it worked as well.

You have put the code in a standard module right, as per the instructions i gave you?

All the files are present in "C:\Scorecards" right?

I believe i followed the instrucitons correctly, And I tried running it with the "lastrow" line above "with sourcedata"
here is a screen shot of the line highlighted for me to debugdebug.jpg


If i remove the "lastrow" line completly it will run the macro and collect the data from the cells i asked for, but only from one xlsx. file, not all xlsx files. and there is no headers obv

Not sure if this will help. I modified a bit.

Please Login or Register  to view this content.

Am glad it worked. Though there was nothing wrong with my code line. I wonder why it was not working.