How to copy alpha & numeric data from multiple workbooks into one master workbook

..........

Could you attach 1 sample Workbook? Ill write you the code in it!

Here is a sample of one of the workbooks.

Thank you!!

Hey!!


Please find the files attached.

Template will be at different locations.

You might have to change the Path of the Master file in the Code Module in Template file as required.

Please let me know if this works..

Press the Update button


Thank you,

Deep

I changed the path of the master file and it worked perfectly! Is there any way to make it where the rows are not removed from the template file after you click Update?

Hey!!

Just remove this Line from the code -

Please Login or Register  to view this content.

But now everytime you update the sheet, the data which was already copied will be copied once more.. Causing duplicates.. Hope that is fine!

Thank You,

Deep

Rather I've made some minor changes for the code to work faster.

Please copy and paste the new code by replacing the old one.

Once again replace the File Path and its good to go..

New Code -

Please Login or Register  to view this content.

Thank You,

Deep

That works! Thank you

I am Glad it does..


Cheers!


Deep