Copy PO to data to logbook, then print the PO

[Yannouh]

Good morning,

I have attached a spreadsheet, i would like to be able to press the data and that it would transfered from PO to Logbook, also to print PO and Clear data in PO.

Many thanks in advance

[6StringJazzer]

What does "press the data" mean?

Also, I have updated your thread title. Please take the time to review our rules. There aren't many, and they are all important. See rule #1.

Also, please update your profile to tell us your Excel version, not your Windows version.

[Yannouh]

i AM ON EXCEL 2000
Sorry i meant data to logbook

[6StringJazzer]

This version copies the data to the log, and prints the PO. I suggest you not clear the PO after you print it because you immediately lose all the data, and you might still need it.

My code to clear column C does not work because of all the merged cells you have. We strongly advise against merged cells and this is one of the reasons. I suggest you redesign your form to avoid merged cells and then update the code to do what you want.

[Yannouh]

Thanks ever so much for your help much appreciated