Date Match in all worksheets according to Main Sheet if not match insert row adjust

[farrukh]

Hi All,

I have a problem i have workbook containing many worksheet 80 + . I need that code check the dates of master sheet column B to all the worksheets if date does not match at the same row then insert row do while the date match all the sheets like master sheet. template is attached.

Means adjust the rows if date 9/8/2010 is placed on master sheet at row A2 then adjust all the rows of all sheet to A2 if did not find the date in sheets then insert row then match dates.

Thanks
FKH

[dangelor]

Possibly this will do what you wish...

Please Login or Register  to view this content.

[farrukh]

HI Dangelor,

Your code is just marvelous it really have done a lot of work. A little amendment required some times i need to Xlup as well how it can be means some time i need to shift up the row to adjust as well according to the master sheet?

Thanks
Hammeed

[dangelor]

Not sure of your meaning...

This part of the code (wks.Cells(x + 1, 2) determines the starting location of your data in each worksheet. For example, wks.Cells(x + 2, 1) should be used if you data started in B3, or wks.Cells(x, 2) if your data started in B1.

HTH,
Rich

[farrukh]

dangelor,

Thanks for your kind help, now i understood . :-)


Many Many Thanks you have saved my time.


Regards,
FKH

[dangelor]

You are welcome. Glad I could help!