Copy and Paste data from 2 wbs into 1 wb and auto save as

[robert12345]

Copy and Paste then Auto save from 2 wbs into 1 wb

Hi Everyone

Would anyone able to help with excel macro for the problem below :


How to copy and paste 2 wbs from 2 locations into one then run macro 1 then auto save the combine wb into the same folder with wb1 , same name as wb1 but add specific text1 and time stamp at the end & (.csv )

After that, the macro will automatically redo copy and paste 2 wbs above into 1wb again then run macro 2 then auto save the combine wb into the same location with wb1 , same name as wb1 but add specific text 2 and time stamp at the end & (.csv)

Note: wb2 is always located at same path D:\Inspect folder\”inspectfile”.csv

To open inspectfile wb2 above , we have to open wb1 , go to cell A1 , get the text in cell A1 ( always in cell A1) then go to folder of wb2 (D:\Inspect folder\... ) and look for the inspecfile which has exactly name as text in cell A1 above to open


Thank so much for your help ,

[huuthang_bd]

It is very hard to help you without your workbooks.

[alansidman]

Read the yellow banner at the top of the page.

[robert12345]

Thank you for the feedback ,
please see the attached files for details ,
Hope it is clear enough ,

Thanks