I am simplifying my excel sheet formatting just so I can ask the essential question..
I have a form that I update daily with market price of a certain commodity.
This form has three columns.
A2: Price on the last WEEKDAY of previous month
B2: Yesterday's price
C2: Today's price
I have a macro setup that I execute everyday around 5PM that does the following: Takes the value in C2 and copies into B2 and clears C2 for today's price.
However, when it is the first WEEKDAY of a new month, I have to always update A2 manually.
Is there a way for my macro to determine if today is the first WEEKDAY of the month and if it is, copy and paste the values in B2 as well as A2?
I hope this makes sense...
I have a form that I update daily with market price of a certain commodity.
This form has three columns.
A2: Price on the last WEEKDAY of previous month
B2: Yesterday's price
C2: Today's price
I have a macro setup that I execute everyday around 5PM that does the following: Takes the value in C2 and copies into B2 and clears C2 for today's price.
However, when it is the first WEEKDAY of a new month, I have to always update A2 manually.
Is there a way for my macro to determine if today is the first WEEKDAY of the month and if it is, copy and paste the values in B2 as well as A2?
I hope this makes sense...