Forum Discussion
Solved
Populating cells with a Date across 12 TABS
Hello Community, If you are up to a challenge and if it possible to accomplish with formulas or VBA I've got a challenge for you. I have 12 sheets in a workbook that look exactly the same. Each wor...
- look at both as decimal (or percentage) are they the same or off by 100? It looks like the rate schedule is a true decimal number (i.e. 0.00088 or 0.088%) while the other number is coming in as % units (i.e. 0.088 which if formatted as % would be 8.8%) so basically you need to convert from % UNIT to decimal value.
=(ROUND(K6,3)= ROUND(100*K$3,3))
or BETTER yet change the formula in K3 to be =100*... so
=100*XLOOKUP(LEFT($I5,3),LEFT('Rate Schedule'!$B5:$B16,3),'Rate Schedule'!C5:C16,"error")
Carl_61 sorry about that. I didn't take into account the difference in the 2 sheet with one having data start on row 3 and the other starting on row 6 (i.e. difference of 3 rows) Hopefully this fixes that issue. Keep the errors coming, we will get is worked out 🙂
I will continue to test this Matt and provide you feedback. As you have already most likely figured out, there are several facets to this System. In addition to the things you have helped me with there are the Overview Tabs for each month that gives me a snap shot (if you will) of where each building falls with its usage of Utilities. As you can see the columns for each Utility shows where the usage falls based on categories. One of the issues I was having was data not falling into it's proper columns and categories. Another words, sometimes data would drop into columns just to the right of the right most column per utility grouping. When the building number was dropping into the columns according to their usage percentage groupings I had wanted to be included with the building number the actual percentage of usage that caused the building number to land in that column. Example: 520/52%, 837/23.52%, 838A/12.67% and so on. This would give visual assurance the building number was in the correct column. Do you have a workbook with the Overview Tabs in it? Do the workbooks I have sent you have the Icons at the top left of the workbook? This is where I have been placing the Macro's for a 1 click launch.