May 13 2021 05:46 AM
Hello,
For tracking data and costs purposes while streamlining our input, we are hoping there is a way in excel that we can have one master list for all data and then when we select a corresponding job that data belongs to it can transfer to a different sheet based of data from that job. I know this sounds somewhat complex (or maybe not at all to some of you), but I would appreciate any help! Maybe this picture can help. Essentially I just want to be able to have it set where if I associate a cost with Job 2 in the master sheet, it will also automatically input that information into the Job 2 sub sheet. Is this possible? Thank you for your time!
May 13 2021 10:02 AM
May 14 2021 07:25 AM