Hello everyone.

I need to count how many times "CASE" appears in a source workbook and put the value in destination workbook where I have my macros working.

It would be great if this could be done without linking the 2 workbooks so that when I close the source workbook I still have the value in my destination workbook.

Does anyone have a macro for this.

Hope I have explained properly.

Thanks in advance.