+ Reply to Thread
Results 1 to 2 of 2

Calendar "like" functionality in worksheet

  1. #1
    Registered User
    Join Date
    11-05-2008
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    67

    Calendar "like" functionality in worksheet

    Hi Folks,

    I'm stuck,
    I need to display the data from a dynamic sheet (I've called it Data) into an easily read format like that on the sheet SA closely approximating a calendar function. The data that comes into the DATA tab is provided via an SQL link to the CRM, used at work - this is static data in this sample file, Linked fields have a blue header, fields created by me have a Green Header.

    The data shown on sheet SA is to be dependant on the "Installation Date" and the "Provisional Install Date", when shown on the SA tab I need to colour code to differentiate confirmed installs to Provisional Installs.

    What I need is some direction on how would be the best way to set this up, either through lookups or via macro's.

    ---This sould be done in 2k7 but I only have 2k3 at home whilst on holidays
    Attached Files Attached Files
    Last edited by sarails; 12-23-2010 at 11:09 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Calendar "like" functionality in worksheet

    Hi sarails,

    It looks like you want to pull data from the Data sheet to the SA sheet based on some criteria and then sort it. Have you considered simply doing a filter and sort on the Data tab itself? Excel 2007 has Auto Tabs that may make your work a lot easier.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

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