I have a master worksheet (sheet1) that I use for several companies. What I
need to do is when I enter data into the sheet1 it will automatically be
transfered into sheet2, but i need it to save the data so that I can clear
sheet1 and still have all the data on sheet2.