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.
Macro will depend on how your workbook is set up (i.e. your data structure) and how often you need to update the value, if there is user other than yourself that could edit the workbook etc.
Please explain scope in full and also upload sample workbook that represent your data (with sanitized info).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
You can use VBA for CountIf.
Assuming the workbook ("Source") is open when you run the code,and assuming it is called "Source.xlsx"
Run the code from the sheet you want the value from and the result will show in A1.
-Check the Wb name
-Sh name
-Range to count "CASE"
Please Login or Register to view this content.
Thanks davesexcel,
It worked brilliantly.
Thanks CK76,
I know the info was missing but the above macro from davesexcel did the trick before I could reply with your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks