Automate Fill - Week and Store No.

[Hammad_Rashid]

Hi All,

Could you please help me how to automate 2 things?

1. Fill Week columns for next 2 weeks, dynamic by checking previous row

2. Keep Store what is on previous row, like 91(this should be dynamic)

Thanks!

[Hammad_Rashid]

Please help!

[Hammad_Rashid]

Anybody?

[Hammad_Rashid]

I got to resolve point 2 by multi row - fill down.

Please help for point 1.

[Hammad_Rashid · Accepted solution]

Resolved 1st point as well :) Conditional + Datetime combination in multi-row.

Thanks!