Macro for Opening and copying data to another workbook with password

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

Thanks guys. I used a variation of this code to suit my purposes.