Hello,
I was wondering if someone could help me / give advice on a macro I need.
I'm guessing what I want to achieve should be quite simple.
I have a blank form (workbook1). Sales fill in the form, and email it to me for logging and circulation.
I then manually input the data onto a spreadsheet (workbook2) and email company wide. I want to slowly automate this whole process or at least make it easier for me as Im getting about 20 - 30 of these forms aday.
So,
I have workbook 1.
Cells E13 , B7, D19 & B2 have the information I want to copy.
Workbook 2 is password protected.
I want to copy the above data to this workbook into column A, B, C & D all on the same row.
Save.
Then when I run the macro again, say the next day on a new / different workbook, I want to copy to workbook 2 again, but in the next empty row.
The macro will be a button which is embedded in the blank template (workbook1)
Can anyone help?
Help much appreciated!
Thanks
Michael
Bookmarks