Consulting

Results 1 to 3 of 3

Thread: VBA and Budgeting

  1. #1
    VBAX Newbie
    Joined
    Dec 2021
    Posts
    1
    Location

    VBA and Budgeting

    I recently started using VBA (Beginner's level), wondering how could VBA help me in preparing and analysing the budget. my budget is in excel file with many worksheets that feed in the main summary sheet.

    Appreciate your help.$

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    Are you open to supplying a dummy version of your main file? Then you need to more clearly define what you need to do when you mean preparing and analysing the budget.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Do you even need VBA? Input the data into a table, and using pivot tables to analyse it.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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