+ Reply to Thread
Results 1 to 2 of 2

To make dynamic bucketwise report from Ageing report while providing days from form

  1. #1
    Registered User
    Join Date
    12-25-2015
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    17

    Red face To make dynamic bucketwise report from Ageing report while providing days from form

    Hello All,

    I'm developing a dynamic bucket wise OS report maker from Ageing report wherein users enter the days through form and by clicking the button "Make Bucketwise", the bucket wise OS report will be generated (adjacent to the ageing report) as per the days provided by users. Here users may enter any day i.e say one may want to make report for bucket 0-21 days however another user may want to generate for 0-16,17-21 and so on. The number of columns in the ageing report is fixed however number of rows may vary. File along with the form screenshot attached.

    I want to know, do I have to write code for every possible combination of bucket days or there is any other smart way to do this.

    Also, if text box/es remain blank on the right side after entering days from the left side, code to run as per the days provided and do not show error, however, there should be at least 2-3 text boxes to be filled by users starting from the left side.

    Any help will be much appreciated.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-25-2015
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    17

    Re: To make dynamic bucketwise report from Ageing report while providing days from form

    I tried to write code for two text boxes and that too from Day 0 to Day 10, the last code is written for three text boxes which is for Day 0 to Day 5, Day 6 to Day 10 and Day 11 & Above.

    Can anyone see this code and assist me in optimising it as I'm wondering there must be any other way round to do it because it needs to be written for a combination of Day 0 to Day 120 Plus into 7 textboxes.
    Attached Files Attached 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. Required Ageing Report
    By haridevadiga in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2019, 09:57 AM
  2. Receivable Ageing Report
    By kumar214 in forum Excel General
    Replies: 1
    Last Post: 11-30-2018, 08:30 AM
  3. [SOLVED] Ageing report in excel
    By sam9989 in forum Excel General
    Replies: 2
    Last Post: 07-16-2018, 12:52 PM
  4. Replies: 3
    Last Post: 07-04-2014, 09:57 PM
  5. Inventory Ageing Report
    By Josher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2013, 09:43 AM
  6. ageing report
    By chiragsk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2008, 10:28 PM
  7. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 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