Macro to paste into next free cell

[sam94]

Hi guys,

At the minute i've made an order form, which when a button is pressed a macro copys certains cells and pastes them into a different sheet in Column A to populate the order form.

Problem is if people click multiple orders - it copies over the previous order, is there anyway to make excel recognise there is data in the first few cells and paste into the next free cell in column c?

Thanks!

Sam

[p24leclerc]

you want to copy to the first empty cell (from the bottom) in column A which is done like this:

Sheets("Sheet2").Cells(Rows.Count,1).End(XlUp).Offset(1,0).PasteSpecial