Copy and paste

Debs269 Posts 23 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Aug 17, 2016 at 08:48 AM

i haven't done much lately with VBA so need some help please

Copying from Sheets("Input (2)") to Sheets("New Items Added")

The rows of data on the input sheet is set up by a message box,
Data is enter from column A:S

This then needs to be copied to New Items Sheet in rows

I need my VBA to

Copy data from first row (input) and copy to next empty row (New Items Added) then go to next row if has data in (input) then copy that to next empty row (New Items Added) I am struggling to get the looping right and also finding the next empty row

The copy & Paste is values and formats only

Once all rows have been copied then clear contents not formulas

Many Thanks for your help