Copy and paste

[Closed]
Report
Posts
23
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
-
Hello,

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

Debs