Vba coding required for count and insert

**meet2mayank** · 02-16-2010, 05:59 AM

Hi Friends,

I need a coding for count of "Reconciled" items and insert that number of template sheets.
Attached is the sheet for your better understanding.

With the help of attached example I need a coding which will count the number of items the word "reconciled" appears and should insert that number of template sheets. In this example the count is 16 so it should insert 16 new template sheets.
Pls note the count would not always be the same and count would not always be in cell L123.
Kindly help.

**rwgrietveld** · 02-16-2010, 06:23 AM

So where can we find the count of "Reconciled" items. Is it a sumation of L20:L63?

**meet2mayank** · 02-16-2010, 06:30 AM

Hi Ricardo...

Thanks for the reply.
Macro should make a Count of "Reconciled" items in column L (L:L) and insert that number of template sheets. Hope I am able to make you understand. Kindly let me know if i can provide you more clue.

Thanks & Regards
Mayank