Using Excel and/or VBA to keep track of how many items are processed

%3CLINGO-SUB%20id%3D%22lingo-sub-2032863%22%20slang%3D%22en-US%22%3EUsing%20Excel%20and%2For%20VBA%20to%20keep%20track%20of%20how%20many%20items%20are%20processed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2032863%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EI%20am%20new%20to%20VBA%20but%20I%20need%20to%20make%20program%20that%20keeps%20track%20of%20the%20number%20of%20items%20that%20are%20processed%20through%20a%20certain%20point%20at%20my%20work.%20I%20have%20a%20table%20that%20is%20constantly%20refreshing%20to%20update%20and%20show%20where%20each%20item%20is%20at%20in%20the%20process.%20I%20want%20to%20know%20how%20I%20can%20keep%20track%20of%20how%20many%20items%20are%20being%20processed%20through%20one%20area%20of%20the%20process%20when%20items%20are%20being%20processed%20to%20and%20through%20that%20point.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2032863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2033267%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20and%2For%20VBA%20to%20keep%20track%20of%20how%20many%20items%20are%20processed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2033267%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917775%22%20target%3D%22_blank%22%3E%40Abraham405%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20for%20you%20to%20post%20either%20the%20actual%20file%20(assuming%20it%20has%20no%20proprietary%20info%20in%20it)%20or%20a%20facsimile%20of%20it--using%20fake%20names%2C%20etc%20to%20preserve%20confidentiality%3F%20It's%20likely%20that%20what%20you're%20asking%20can%20be%20done%20quite%20readily%2C%20but%20without%20seeing%20how%20that%20file%20you%20are%20working%20with%20is%20arranged%2C%20it's%20next%20to%20impossible%20to%20give%20any%20really%20practical%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am new to VBA but I need to make program that keeps track of the number of items that are processed through a certain point at my work. I have a table that is constantly refreshing to update and show where each item is at in the process. I want to know how I can keep track of how many items are being processed through one area of the process when items are being processed to and through that point. 

 

Thank you

1 Reply

@Abraham405 

 

Is there any way for you to post either the actual file (assuming it has no proprietary info in it) or a facsimile of it--using fake names, etc to preserve confidentiality? It's likely that what you're asking can be done quite readily, but without seeing how that file you are working with is arranged, it's next to impossible to give any really practical suggestions.