Look up cells in one sheet and add to another
I am trying to create a timesheet form that would automatically populate from Sheet name (Calendar) to Sheet name (Timesheet). I keeping track of my time and jobs I work on through Microsoft Office Calendar. I want to export that info at the end of each week and import it into the Timesheet form. I have attached a sample of what I would like do to. Might be to much but I am lost. Tried vlookup, if, and index formulas with desired result.
Thanks for any help
|