Hello Guys

I need a macro to be attached to a button on a worksheet called "Quote tool" that will start a new line on a worksheet called "All Data" in the next available row.

I currently have the data produced in the "quote tool" worksheet transferring onto row A9 of the "All Data" worksheet and would like a button that once pressed moves the data in row A9 down a line but leaves the data (and formatting) in A9, so the operator can reconfigure the data if required but does not effect the original line.

I hope i have explained myself so its understandable.....

Thanks Nelly