Code to move values

[Mark F]

Hi All

Looking for some VBA help

I need the code that will (at the press of a button) copy cell values as follows:

From Sheet 1 cells a3, b3 and C3

Into Sheet 2 into columns E, F and G on the next completely blank row

Ie If a cell has any data in any columns then the contents of Sheet 1 a3, b3 and C3 need to go on the next row down

Thanks for any help

Mark

 

[boxsterman]

Record the macro to do what you want it to do.... then insert a button from the forms menu (or other one) and attached the recorded macro to the button.

Easiest way to do it.

 

[boxsterman]

sorry ignore my post.. didn't read about the next empty row.....

 

[Mark F]

Following on from earlier, just wondering if there are any suggestions

Cheers

Mark