I have two sheets that I'm working with. The first sheet is an entry sheet where a part number and quantity are entered. The second sheet keeps a list of what is entered on the first sheet. Basically I want to cut the part number and quantity from sheet one, paste those values into sheet two, and then clear the info entered on sheet one. Then, when the next part number and quantity are entered into sheet one, I want that information cut and pasted directly under the previous information in sheet two. And then keep repeating. Any ideas on how to accomplish this with one macro? Thanks.
Bookmarks