Auto fill daterangeClosed

Question

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

Dainesy · Answer

using excel.

Dainesy · Answer

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

Dainesy · Answer

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.

Auto fill daterange

3 responses

Similar discussions

Subscribe To Our Newsletter!