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
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.