Not sure if this is possible or not, but is there a way to have a 4th sheet in a workbook that will search through the first 3 sheets and compile the date & time info as it is entered daily?
Here's the thing:
I have a tracker where meeting dates & times are entered on sheet 1.
Phone log date & times are entered on sheet 2.
Admin dates & times are entered on sheet 3.
I need a sheet 4 that will be able to populate data as it's entered into the first 3 sheets.
Say I have a meeting from 12:00PM - 2:00PM and enter that on Sheet1. I do Administrative work from 2:00PM - 3:00PM. I have conference calls from 3:00PM - 4:00PM.
Sheet 4 would ideally compile like this:
. Column A . Column B . Column C . Column D
02/11/2014 . 12:00PM . . 2:00PM . . . Meeting (<Just displaying the sheet it came from)
02/11/2014 . 2:00PM . . . 3:00PM . . . Admin
02/11/2014 . 3:00PM . . . 4:00PM . . . Call Log
As the month progresses, it just adds the next entered info to the next available line.
Is this something Excel can do? And if so, how do I do it?!
Bookmarks