+ Reply to Thread
Results 1 to 3 of 3

Creating an Aging Report that reads data from multiple sheets

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    1

    Creating an Aging Report that reads data from multiple sheets

    I no longer need assistance with this issue

    Original Query:

    I am trying to create an Aging Report that takes a look at a customer sheet and a transactions sheet and reads the data and different invoices for each customer and adds the totals and looks at the terms for each customer and places them in different time buckets according to the date that is on the user form. After it reads the information and puts it in the right place and creates a new sheet as seen in the pictures, I want it to open the print preview window and have the entire aging report fit on the print preview. Not sure where to get started with this.Attachment 632683Attachment 632684Attachment 632687Attachment 632688
    Last edited by AliGW; 07-17-2019 at 01:33 AM. Reason: Message reinstated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Creating an Aging Report that reads data from multiple sheets

    Please do not delete your questions, also please provide your answer - other members may have the same need.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Creating an Aging Report that reads data from multiple sheets

    This was your original post....
    I am trying to create an Aging Report that takes a look at a customer sheet and a transactions sheet and reads the data and different invoices for each customer and adds the totals and looks at the terms for each customer and places them in different time buckets according to the date that is on the user form. After it reads the information and puts it in the right place and creates a new sheet as seen in the pictures, I want it to open the print preview window and have the entire aging report fit on the print preview. Not sure where to get started with this.
    You also attached some files?

+ 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. Need help in creating Aging report by project based in FIFO method
    By dhowlathkhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2018, 01:19 PM
  2. creating an aging report
    By PSikes in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 12:07 PM
  3. Creating a report from multiple sheets based off of criteria
    By nycguy1128 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-26-2016, 05:05 PM
  4. Help creating an aging report for open credits
    By Biff.. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-26-2014, 08:53 PM
  5. creating an aging report
    By azmil in forum Excel General
    Replies: 8
    Last Post: 02-21-2014, 03:45 AM
  6. creating an aging report
    By azmil in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-21-2014, 03:22 AM
  7. [SOLVED] Creating AP Aging Report
    By StingMC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 12:05 AM

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