Is it possible to ‘capture’ data from various spreadsheets on a ‘master’ sheet in the same book AND retain that data even if the data is changed on an individual spreadsheet? These are two separate questions. Here is the scenario.
See the attached Excel workbook. I haven't entered any formulas yet...that's what I need help with, please.
Each sheet has the same Column Headings except the Master, which has one more “Individual”
If Dick enters data on his sheet on Row 1, I know how to capture that data on Row 1 of the master sheet, but then if Harry enters data on his sheet on Row 1, how do I capture that same data on the next blank row of the Master sheet rather than overwriting the data captured from Dick’s sheet the day before?
Also, is there a way to retain an initial entry in a cell even if it is changed or deleted? For instance, if Paul enters training data in a row of his sheet on 4/20/17, and I’m able to capture that same data on the Master sheet; then Paul changes the “Date Entered” from 4/20/17 to 4/25/17. Can the Master sheet retain the initial date Paul entered?
I’m thinking I could put a formula in Column A on the individual sheets to enter “TODAY” whenever data is entered on that Row, and I could protect that cell from being changed, but wouldn’t that cell also be updated with today’s date whenever someone goes in and changes the status of a line item?
I’m self-taught in Excel from books and forums and have a lot to learn, but some of these unique scenarios aren’t covered in books. Can you help me, ple