Results 1 to 3 of 3

Looking up values and returning items into a calendar format.

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2006
    Posts
    6

    Looking up values and returning items into a calendar format.

    I have used to Excel Query to resolve this issue before, but I was hoping someone could provide a formula combination for the calendar on the attached sheet that does not use queries. It seems that when you rename the file or someone forgets to save it in the right place, the queries naturally do not work. I do not know how to quickly change multiple queries to direct them to the right location. I am providing this to someone who may not save it in the sam eplace or may change the name of the file.

    Issue: So, I was hoping that someone could show me a formula (on the attached Calendar sheet) that would look up on the master sheet all of the adjacent information for the the corrresponding goals on the master sheet within, lets say, the September 07 timeframe and list the required information. It would be great if it added a row to adjust if and when additional goals are added to the master. I guess I could use queries again if someone would explain how to quickly change the file source location and name (should it change or if it gets renamed), but it would be great if I could do it with formulae.

    thanks so much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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