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")
The conditional formatting formula is always RELATIVE to the 'Applied To' range. So if your conditional formatting range on the Tally Sheet starts on row 4 then that formula MUST reference row 4:
=ISNUMBER(MATCH(A4,'GO List'!$A$3:$A$52,0))
As for the Electric %, when I open the 1352 report I see the rate as 0.088 and the same when I open the UMS Workbook. That RATE is the same as 8.8% and when I click on or highlight cells on the UMS and either click the % button or use the drop down and select percent, they change to the corresponding % value (note sometimes it will show 9% but then click the 'increase decimal' button (2 buttons to right of % button) to show more decimal places and it will show you 8.8%)
=ISNUMBER(MATCH(A4,'GO List'!$A$3:$A$52,0))
As for the Electric %, when I open the 1352 report I see the rate as 0.088 and the same when I open the UMS Workbook. That RATE is the same as 8.8% and when I click on or highlight cells on the UMS and either click the % button or use the drop down and select percent, they change to the corresponding % value (note sometimes it will show 9% but then click the 'increase decimal' button (2 buttons to right of % button) to show more decimal places and it will show you 8.8%)
I forgot to also ask, as the Run Data Prep Macro only appears to process the Electric stuff, how do we make the Gas Data Prep work? As both of these come from the same 1352 would it not be prudent to process both of them when that button is clicked?