Good afternoon all.
Noob here (breaking the rule and making post#1 a request for help!)
I have an excel spreadsheet which currently has 3 tabs.
1 is active, 2 is not active and 3 is completed.
The spreadsheet was set up like this to easily monitor the numbers in the three different stages (before I learnt more about excel and could've left it all in one?).
This information is reported on monthly in great detail, and "reviewed" daily/ weekly.
I want to create sheet 4 which will be a combination of 1,2 and 3 and then use this for reporting. Others may use this sheet, so it's better that it doesn't edit the data in the other three sheets. This will involve reports on % of current status, time lapsed, total number between 2 dates etc.
All data starts on sheet 1, worked on and tracked for updates, and then moved to either 2 or 3. At the stage in which it is to be moved across, it turns either green or red, for completed or not active. At present, the colour is merely conditional formatting, but the information is then cut and paste into one of the other sheets. At present, they are NOT set up as tables (I have since learned the error of my ways and will look to format as a table shortly). Can this be done manually?
Also, the reoprting dates are not 01/one month - 31/one month, it's split based on the third week of every month as a cut off period. Is there any way the graphs can display this without creating a calculation and another table?
I am sure I've not made myself perfectly clear, but would love if someone could assist with this matter. It is currently taking me 1-2 days per month to report on this information. I've started to automate it, however this would be the final hurdle to make it automated and extremely helpful.
Kind regards,
Michael
Bookmarks