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
Bookmarks