I've been trying and failing miserably to get this to work as I'm only a beginner at VBA in excel. Hopefully somebody can help me out with this. Instead of pasting my jumbled mess of code, I think it might be easier for me to map out verbally what I'm trying to do in this instance.
I have Workbook A that has a button in it. When I click that button, I would like it to create a new workbook (Workbook B) by using a template workbook that exists in another folder location, and prompts the user to save the new workbook in the same location as Workbook A with whatever name they choose.
When this new Workbook is created/copied from the template workbook, I need it copy values from Workbook A into various cells in Workbook B.
The cells that need to be copied over from Workbook A to Workbook B are as follows...
C3 to D4
C4 to D5
C5 to D3
E2 to G3
E3 to G4
E4 to G5
E6 to K3
F1 to K4
C1 to K5
I also need to copy the filename of Workbook A into cell A2 in Workbook B.
Any help with this is much appreciated. Thank you in advance.
Bookmarks