MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is there a Macro that will create a list?


Posted by Barbara on March 28, 2000 8:03 PM

Can someone help me create a macro to do this?

Sheet1 is a check list where only 6 input items are to be tracked on to sheet2.
Then I want the 6 input items on Sheet1 to clear(to be ready for the next set of information)
When the next set of info is typed into Sheet1, I want it moved to the NEXT line on Sheet2, thereby creating a list.

I don't know how to create a macro that will create a permanent list on sheet2 when the information is cleared from sheet1.


Posted by Celia on March 29, 2000 1:36 AM

Barbara
Each time the input to cells A1:A6 on Sheet1 is completed, run the following macro :-

Sub Copy_Paste_Clear()
Sheets("Sheet1").Range("A1:A6").Copy _
Destination:=Sheets("Sheet2").Range("A65536") _
.End(xlUp).Offset(1, 0)
Sheets("Sheet1").Range("A1:A6").ClearContents
End Sub

Celia