I have a spreed sheet set up to log information on (sheet 1). On this sheet, it is a dynamic work sheet that we enter names on that we are currently working on. When we are finished, the name gets erased. There are three catagories that names get put under (cat 1, cat 2, cat 3). We also need to keep a master log for each catagory that will keep all of the names that we have done work on (sheet 2, sheet 3, sheet 4).
Currently when we enter a name and info on the work sheet we need to then copy and paste the info into the appropriate Log. This needs to be done for each new entry on the work sheet. I would like to see if it is possible to have that information be copied to the appropriate log automatically.
Names and info are added and deleted from the work sheet as work is started or completed but the logs need to keep the names and info.
Any help would be appreciated.