Macro to show day of the today

**graiggoriz** · 05-21-2014, 04:02 AM

Hello,

Would you know a macro that would do the following:

1) I need to have the cells (AS2,AS10,AS16,AS22,AS28,AS34,AS40,AS46) automatically copied based on the today day (row 4:4).
I have attached a sample planing Where I have in the "Sheet1": on the left my current planning and on the right what I would need to get. The tab "Planning" is my current situation

2) I would need to always have the column in grey below the "S" present in row 3:3. Please check the example attached.

Thanks,
Graig

**nathansav** · 05-21-2014, 04:47 AM

Does it have to be a macro, it could be done using IF and conditional formatting?

**graiggoriz** · 05-21-2014, 04:52 AM

I doubt as I insert range trhought the belwo macro:

HTML Code:

I also have the macro in the "planning" sheet:

HTML Code:

**nathansav** · 05-21-2014, 04:59 AM

Does teh macro draw the sheet that you've attached, quickly looking i dont think it does, rows 2, 10,16 etc, could have the if formula in and conditional formatting can be applied to a sheet with no data. As long as the sheet isnt created by code, itself not the presentation, then the cond formatting will remain.

If ive got the wrong idea, please elaborate. Its still early :o)