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.