+ Reply to Thread
Results 1 to 6 of 6

Trying to automate a task with vba

  1. #1
    Registered User
    Join Date
    09-28-2020
    Location
    Berlin, Germany
    MS-Off Ver
    365
    Posts
    3

    Trying to automate a task with vba

    Hello,



    I need help automating this.

    What I want to do is simply display the cash outflow amounts per vendor on a monthly basis.



    Example: In Jun 20 (Column C) the amount owed to the Vendor: Builder (Cell A3) is 314.914,85. This number would come from Amount (Column L) in the ‘Entries’ tab by referring to Month:Jun 20 (from Column A) Vendor:Builder (Column F )and Cost Group: 300 (Column H).

    So something like
If it is August 20
Look for Entries of August 20 in the Entries tab
then match the vendor and the cost group
and display the corresponding amount in the cashflow tab



    I’m quite new to VBA and am getting nowhere.

    Thank you so much for your help.
    Attached Files Attached Files
    Last edited by im.mrfrank; 10-02-2020 at 10:01 AM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Trying to automate a task with vba

    Wouldn't a pivot table suffice...?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-28-2020
    Location
    Berlin, Germany
    MS-Off Ver
    365
    Posts
    3

    Re: Trying to automate a task with vba

    It does to an extent thanks. The thing is: There are more cells which would be dependent on this table which I want to make and that is why I wanted it done through vba so that the dependencies can refer to this table and that the pivot doesn't lose its formatting everytime I refresh.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Trying to automate a task with vba

    Possibly with a slight change to your layout...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-28-2020
    Location
    Berlin, Germany
    MS-Off Ver
    365
    Posts
    3

    Re: Trying to automate a task with vba

    wow this works great.
    thanks

  6. #6
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Trying to automate a task with vba

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to automate our reporting task
    By geh17 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2017, 12:21 AM
  2. Can I automate this task using VBA, Excel ?
    By Coco87 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-05-2015, 06:49 PM
  3. Need to automate find/copy task
    By Matt26 in forum Excel General
    Replies: 7
    Last Post: 03-06-2014, 12:17 PM
  4. VBA code to automate simple task
    By itselflearn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2013, 12:11 PM
  5. Excel Help - advice on how to automate this task
    By KingLeviathan in forum Excel General
    Replies: 2
    Last Post: 08-23-2010, 08:28 AM
  6. [SOLVED] How to automate this task
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 07:45 PM
  7. macro for excel, automate task
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2006, 10:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1