Hello,
I have the below code:
This code works fine in the set ranges of T4:T30, W4:W30, and X4:X30 but now I would like to make these ranges dynamic.
Please Login or Register to view this content.
For example, based on the Date in D1, find that date in Row 3, and work in that area. Would this be possible using Offset?
Hi, Not sure I can get your macro working as I'm not sure exactly what it does BUT as far as converting the fixed references to columns to variable references maybe try this. I set variables for the MOH value in the same month, the MOH column in the prior month and this column value for the chosen month. I assumed column "i" stays fixed and the others move relative to the chosen date. The dates were 2023 but your field in D1 was 2022 so I changed that and it at least seems to make amendments to the correct columns.
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Similar approach to Crooza's one above
Note, it should really have error trapping because if the date in D1 does not appear in row 3 (as per your example file) then it will fall over.Please Login or Register to view this content.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks