+ Reply to Thread
Results 1 to 2 of 2

Priority Task automated from project sheets

  1. #1
    Registered User
    Join Date
    07-17-2009
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    28

    Priority Task automated from project sheets

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Priority Task automated from project sheets

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1