+ Reply to Thread
Results 1 to 2 of 2

Printing Individual Reports from Non-Blank Rows of Data

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Printing Individual Reports from Non-Blank Rows of Data

    I am new to this so here goes
    I need help
    I am using Xcell 2020
    I need some help doing a report on spreadsheet that has approx. 200 columns across and will have about 700 lines of data in them across and down the page.
    I want do a report one row at a time excluding the columns that don't have data in it.
    I need to be able to print it out like a invoice
    I hope I am explaining my self
    Thanks everyone
    Last edited by AliGW; 02-18-2020 at 03:00 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)

    Re: Printing Individual Reports from Non-Blank Rows of Data

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I have done it for you this time.)

    Your requirement will need VBA coding - I am moving the thread accordingly.

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.

    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.

+ 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. Call in the Cavalry - 2020
    By JBeaucaire in forum The Water Cooler
    Replies: 97
    Last Post: 12-15-2020, 04:27 PM
  2. DoneEx XCell compiler - anyone used this add-in to turn a workbook into exe?
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2013, 03:52 PM
  3. Convert text to number cDec(xCell.Value)
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2012, 01:49 PM
  4. place images automatically in xcell
    By verena in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2009, 09:28 AM
  5. populating xcell with numbered list
    By Nipper in forum Excel General
    Replies: 4
    Last Post: 01-06-2009, 11:42 PM
  6. Display cell contents in one xcell doc. from another xcell doc.
    By Zippy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2006, 02:15 PM
    By Asterix in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2005, 09:06 PM


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