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")
so no I did NOT notice that the lists on each tab don't line up and if that must be the case then you will need to use a LOOKUP formula (recommend XLOOKUP as it appears they improved the efficiency of it). That said, if you can avoid that and force all tabs to have the exact same row structure (i.e. bldg 123 is always on the same row) then you can use the formula I used which was a more simple IF condition applied to the range and therefore each row would fill in the corresponding row value. Since you already have a macro inserting and lining up the data you could have it insert buffer lines on all the other tabs accordingly. BTW, I also do VBA if there is a question there too, not that I need or want more work. lol.
As for the GO list, it is convenient to have the Incomplete list there for conditional formatting rule but otherwise you can easily copy it to its own sheet and make its own rule.
gtg to a mtg right now but I'll try and look at the rest of the questions later.
As for the GO list, it is convenient to have the Incomplete list there for conditional formatting rule but otherwise you can easily copy it to its own sheet and make its own rule.
gtg to a mtg right now but I'll try and look at the rest of the questions later.
Hello today Sir, I am happy to hear that you also partake in the VBA Code world. I posted on Dec 12th a request for help and am still waiting for a reply. The name of the post is VBA Code Modifications. Please check it out! I am happy to provide additional helpful information should you need it.