Copy Column Based on Date Criteria
Posted on 2011-09-19
Need some help with some coding in Excel VBA which will do...
I have a Budget sheet, on the master sheet it currently has all the days covered for the next 10 years, i.e. some 3,650 columns which take forever to load!. Having reviewed what is actually happening only about 8 days a month actually show what is going out, so basically I need to be able to copy the entire column from Column D (which contains all the relevant forulas required) and place it in E, then F and so on as much is required to cover 10 years worth.
It needs to read in a range from =Summary!D8:D27 which contains the days actually used for any transfers to show, but must also include every FRIDAY regardless. And then change its Row 3 of its own column to reflect the actual date. The initial start date must come from D3 (Which would contain the day, month and year) to start with.
Then duplicate this method to to show ten years worth of columns and be dynamic so I could change my mind to say 20 yrs!.
Hope that makes sense.