Results 1 to 2 of 2

using if/then and using sorting to parse data and create list without spaces

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    nyc
    MS-Off Ver
    Excel 2010
    Posts
    3

    using if/then and using sorting to parse data and create list without spaces

    I am looking to use a sales database to create an invoice. i would like to use a y/n flag under an invoice column which would determine that an invloice would be populated with data for that customer from the sales database. there are many products and not always a sale of each item so there are lots of products that will need to be left off the invoice.

    What i would like is to create an invoice that lists the products purchased. i have included a sample of what the sales database looks like.

    The invoice will list the items vertically.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List of Valuses with Spaces and make a new list without spaces.
    By omallyfoster in forum Excel General
    Replies: 6
    Last Post: 05-21-2013, 08:14 AM
  2. Parse string with various length consecutive spaces
    By Excelvator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2012, 07:43 PM
  3. Replies: 1
    Last Post: 06-10-2011, 06:32 AM
  4. Macro to parse a column with empty spaces
    By bearswentwild in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-14-2011, 01:02 PM
  5. Parse list of data to template in different worksheets
    By pmhabo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2010, 06:49 PM

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