Hi,
I would like to have one excel sheet that tells me what all of Priority 1 tasks are for the day (sheet is called "Today")
The Today sheet would look up this information from other sheets in the same spreadsheet. I would have various sheets (Projects), for example Home, Work, etc., that list Tasks for that Project. Therefore each sheet has information listed by Priority, Task and Descriptions.
For example:
Each Sheet is organized by
a1 = Priority, b1 = Task, c1 = Description
Sheet "Home"
a2 = 2, b2 = buy milk, c2 = skim milk
a3 = 1, b2 = change light bulb, c2 = 20 watt
a1 = 1, b2 = cut grass, c2 = (no description)
Sheet "Work"
a2 = 1, b2 = pay invoice, c2 = electric bill
a2 = 1, b2 = buy Ink c2 = electric bill
Tab "Today"
a2 = 1, b2 = pay invoice, c2 = electric bill
a3 = 1, b3 = buy Ink c3 = electric bill
a4 = 1, b4 = cut grass, c4 =
Vlookup did not work for me.
If its already been ask - please send me the link.
Thanks for your help.
Jason
Bookmarks