I'm attempting to use an excel workbook that contains 2 worksheets for 2 purposes:
1. Summarize data and display in sheet A (project estimates) that is listed in detailed records in sheet B (associated project task entries) and 2. validate items entered in sheet B (task entries) against entries in sheet A (project estmates).
Just can't seem to get the structure working...Is this beyond what excel can do easily and I should just "punt" and use ACCESS?
Maybe someone could point me to an example of a similar structure or just get me started (major hang up is formula referencing ie "PROJECTS" in sheet A from sheet B and vice versa).
Thanks in advance.