Consulting

Results 1 to 2 of 2

Thread: Physical Counting

  1. #1
    Banned VBAX Newbie
    Joined
    Dec 2023
    Posts
    1
    Location

    Physical Counting

    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

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    337
    Location
    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.
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •