Previous Topic Next Topic

Auto fill daterange

Closed
Dainesy - Aug 27, 2009 at 11:42 AM
 Dainesy - Aug 27, 2009 at 11:52 AM
Hello,
I'm looking to compose a macro to automatically fill a date range for example
if c1 = 10/10/09 then d1 = one week after "17/10/09" e1 = 2 weeks after "24/10/09" and so on until 4 weeks time.
also if b1 = w then above script kicks in but if b1 = m then script will not run.

any idea would be a great help
Related:

3 responses

Answer 1 / 3
Dainesy
Aug 27, 2009 at 11:44 AM
using excel.
0
Answer 2 / 3
Dainesy
Aug 27, 2009 at 11:49 AM
one other thing, this is for the whole spreadsheet, the exact ref range will be if d10:d65536 = w then autofil with date range e10:e65536 f10:f65536 g10:g65536 h10:h65536
0
Answer 3 / 3
Dainesy
Aug 27, 2009 at 11:52 AM
sorry this may seem a little confusing i actually mean
if d10= w then autofil with date range e10 f10 g10 h10
if d11= w then autofil with date range e11 f11 g11 h11
and so on...
sorry about the half questions and not complete discription.
0