Macro to perform multiple jobs

[cafc_fuller]

Hello,

I need a macro which will perform 5 simple tasks on my Customer sheet once a button is clicked:

1) Change Cell C15 (Drop down box) Value from "Confirmation" to "Delivery Note"
2) Put the current date in Cell H43 (I do not want this to update everytime i re-open the spreadsheet however) - is this possible?
3) Value of H23 to be the same as C16 on the Delivery Sheet ( guessing this will be =Delivery!$C$16)
4) Print Customer sheet
5) Print Delivery sheet

Is this possible?
I'm guessing the hardest part is to stop the date changing?
If someone could help me that would be great.

Thanks
Darren

[Kiwoop]

(I do not want this to update everytime i re-open the spreadsheet however

I don't get your point , current date needs to be updated to be "current" doesn't it ?

[cafc_fuller]

Basically its the date that the order is despatched. So it would be today - however if you use the Today function it updates everytime you go back into the spreadsheet.
Does that make sense?

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[cafc_fuller]

That's great - thanks

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.