Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2015
    Posts
    5

    Question How to generating a person specific task list based on a given date and event type

    I have an excel spreadsheet that with individual rows like this:



    Date Event Type Artwork Type Artwork Due Bulletin Entry Post 1 Date Post 1 Content
    25-Dec-15 Fun/Occassional Standard 10-Dec-15 20-Dec-15 15-Dec-15 Short announcement of event

    The first two columns are the only information I fill in. (Event Type is chosen from a drop down). The rest of the information is generated through nested IF formula's.

    The problem is that this is starting to become unwieldy.

    I have been told this could be much better achieved with Access.

    Does anyone know how to do this? I would appreciate the help!

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    You'll need to better explain what it is that the Excel is doing and even showing the nested IF might help.
    Explain it as if we don't know what you're doing.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Learn. Relational database principles, Access functionality, programming concepts, VBA language/syntax and/or macros. Start with http://www.rogersaccesslibrary.com/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Join Date
    Nov 2015
    Posts
    5
    Hi James,

    Would attaching the excel sheet help?
    Or would an explanation be more helpful?

  5. #5
    Join Date
    Nov 2015
    Posts
    5
    Thanks, June. Will take a look at that now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-03-2015, 11:31 AM
  2. Replies: 5
    Last Post: 07-28-2014, 04:05 PM
  3. Replies: 3
    Last Post: 12-09-2013, 08:53 AM
  4. Generating List and Narrow down to type
    By bhaktharvali in forum Database Design
    Replies: 2
    Last Post: 01-07-2012, 03:39 AM
  5. Replies: 4
    Last Post: 07-27-2011, 12:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums