Look up cells in one sheet and add to another

[aulrich28]

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

[macropod]

Hi aulrich,

This is possible with formulae, but they're quite complex. To complicate things, your data appear to have some errors on the Calendar sheet:
• D8 is empty
• on row 6, you appear to have start & end times of 8AM & 12AM, respectively, on the same date - either the end time should be 12PM (for a noon finish) or the date should be the next day (for a midnight finish).

The attached workbook has the formulae filled in for the first day - just to give you an idea of the complexity. Correct the above errors and you'll get some meaningful output.

[aulrich28]

Thanks for putting me on the right path Macropod. I will give it a look and let you know how it turns out.