Insert rows on missing days

[RD400]

Hi,
New to writing VBA I can normally adapt other code to do what I want but this time I'm stuck. what I'm trying to do is, for every store number I need the missing days inserted (rows) so every store has 7 rows. 1=Sun <>7=Sat, then the day number in column A on the blank row. I have attached a sample workbook. Day number is in column A & store in C

Any help on this would be appreciated, Regards RD400
DAY_DATE LOOKUP Store
2 00002_Mon 00002
4 00002_Wed 00002
5 00002_Thu 00002
7 00002_Sat 00002
2 00003_Mon 00003
4 00003_Wed 00003
6 00003_Fri 00003
7 00003_Sat 00003

 

[NARAYANK991]

Hi ,

Can you first go through the tab named Output , and confirm that what is shown there is what you are looking for ?

Narayan

 

[RD400]

Hi Narayan,

Yes that's just what I'm looking for, what did you use ?

Thanks for the reply.

RD400