Closed Thread
Results 1 to 4 of 4

Combined table by adding each date to fixed header line on seperate sheet by using

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combined table by adding each date to fixed header line on seperate sheet by using

    Hello Brave Excel Lovers and Helpers

    I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached)

    RawDatabase
    ReportTemplate
    MyReport

    I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then manually process by copy and past each new data to generate report like ReportTemplate.

    Anybody please help me how can I generate Report Like ReportTemplate from Userform Listbox1 by selecting multiple rows from Listbox1 and add them according to Headers in ReportTemplate.

    Colors are only for reference of Helpers and sorting is also not necessary. Just want to create report like ReportTemplate.

    Thanks in advance.

    "Tags = Report, Template, Header, userform, listbox, Excel"
    Attached Files Attached Files
    Last edited by AliGW; 02-05-2021 at 02:58 AM. Reason: Redacted for legibility.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,174

    Re: Combined table by adding each date to fixed header line on seperate sheet by using

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I will provide the link for you this time: https://www.excelguru.ca/forums/show...ate-sheet-by-u.)

    MULTIPLE CROSS-POSTS:

    https://www.mrexcel.com/board/thread...g-vba.1160789/

    https://www.ozgrid.com/forum/index.p...postID=1244311

    https://chandoo.org/forum/threads/co...ing-vba.45773/
    Last edited by AliGW; 02-06-2021 at 09:28 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    02-02-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2
    Yes just to get solution as i think this forum has no potential for this solution.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,174

    Re: Combined table by adding each date to fixed header line on seperate sheet by using

    You didn't wait to find out before cross-posting, but that's fine - I'll close the thread, as you will have no further use for it, and I note that you have not acknowledged that you understand that you have broken a rule or apologised for doing so.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line Graph question - vetical line values at one fixed date
    By bohn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2015, 02:22 PM
  2. Pivot Table with multi-line and combined columns
    By KeOt777 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-19-2015, 08:37 PM
  3. [SOLVED] How to populate the data accordingly into a table with fixed header from raw file?
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-13-2015, 11:28 AM
  4. Trying to copy fixed row of cells, paste to next empty line, and clear fixed line.
    By oh_stanley in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-24-2014, 07:44 PM
  5. Seperate cells by adding null line according to numbers
    By alogoc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2009, 07:10 AM
  6. Adding a fixed date to a cell
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  7. Adding a fixed date to a cell
    By Erik Jahre in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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