+ Reply to Thread
Results 1 to 2 of 2

Having trouble creating macro to compare monthly reports and calculate differences

  1. #1
    Registered User
    Join Date
    01-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016
    Posts
    6

    Having trouble creating macro to compare monthly reports and calculate differences

    See attached file for example.

    Each month we have to run a report and I thought it would be a good idea to be able to analyze the differences in the reports on a monthly basis.

    Ex. first sheet we downloaded in Nov. 2021
    - have several different products, with values corresponding to each month

    second sheet is ex. of what was downloaded in Dec. 2021
    - have some similar products, some different, with new values for each month

    Ideally what I want to be able to calculate is sheet number 3 (the comparison) and be able to see the biggest differences (like in tab 4). Too hard to do manually as there are normally thousands of lines, and the products are not always the same.

    No idea where to start with a macro so I'd see if anyone here had any advice.

    Thanks in advance
    Last edited by will12321; 11-05-2021 at 04:00 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Having trouble creating macro to compare monthly reports and calculate differences

    No file attached.

    The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Macro to v look up and compare reports
    By arun.sj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2015, 03:14 PM
  2. Identifying Differences in Monthly Reports
    By nadrojylloh in forum Excel General
    Replies: 8
    Last Post: 07-28-2014, 06:57 PM
  3. Compare column A with B and calculate differences
    By mrcois in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2010, 03:07 PM
  4. Turning Daily Reports into Monthly Reports
    By jambezi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2009, 05:31 PM
  5. Macro Updating Monthly Reports
    By blk91rs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2009, 04:49 PM
  6. How to calculate monthly & quarterly reports
    By island_monkey in forum Excel General
    Replies: 7
    Last Post: 02-04-2009, 12:53 PM
  7. [SOLVED] having trouble creating chart to show monthly totals
    By Ian Roberts in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2005, 09:40 PM

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