I have a spreadsheet for timesheets and there is a mix between 4 and 5 week months that means the formatting changes and so do some of the formulas. I'm wondering if it would be easier to use two seperate spreadsheets depending on the month, or if it would be reasonable easy to do a macro that read
if this cell equals 5 then insert columns and change put these formulas in.
or if its easier to do it the other way and have if this cell reads 4 then delete these cells.
I'm a bit of a newbie to VBA in the grand scheme of things, but I have written a few macros that use loops and some other bits. I just havent come across how to do this yet!
Help is always appreciated.
Janni
if this cell equals 5 then insert columns and change put these formulas in.
or if its easier to do it the other way and have if this cell reads 4 then delete these cells.
I'm a bit of a newbie to VBA in the grand scheme of things, but I have written a few macros that use loops and some other bits. I just havent come across how to do this yet!
Help is always appreciated.
Janni
