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

Attached Files

Sample Timesheet.xlsx (23.2 KB, 12 views)

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.

Attached Files

Sample Timesheet.xlsx (25.1 KB, 19 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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