PDA

View Full Version : [SLEEPER:] Physical Counting



Misprision
12-27-2023, 01:21 AM
Greetings,
I am a real beginer in VBA.
Looking for your kind support to figure out how to use VBA to do monthly check on and compare System Figure VS Physical Counting.
Every end of month multiple PDF files are recived to manually enter physical inventory data to compare it with the the data in system(provided in excel) , is there away to preform this activity with a touch of a button?
Let me know if further information is required and many thanks in advance.
Many thanks

June7
12-27-2023, 02:25 AM
Most anything is possible with enough code but a lot more information is needed. Exactly what do you need done with "touch of a button"? Pull data from PDF files then do data analysis? VBA might not be the most efficient method for comparing data. Maybe a database like Access and queries would be better route.