+ Reply to Thread
Results 1 to 3 of 3

Auto generate # of invoices based on value in a cell

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Cleveland, Ohio
    MS-Off Ver
    Office 16
    Posts
    12

    Unhappy Auto generate # of invoices based on value in a cell

    I have a project that I am working on where I need to create a certain number of invoices based on a cell value. i.e. If the cell has a value of 15, then I need my excel sheet to generate 15 identical invoices that I can print. Not sure how to do this, anything helps. Thanks so much.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Auto generate # of invoices based on value in a cell

    If they are identical, why not just have one invoice and print 15 copies?

  3. #3
    Registered User
    Join Date
    05-21-2019
    Location
    Cleveland, Ohio
    MS-Off Ver
    Office 16
    Posts
    12

    Re: Auto generate # of invoices based on value in a cell

    I guess I explained that incorrectly, almost identical with minor differences. For example, the bottom of the invoice has to say 1 of 15, 2 of 15...etc., it is connected to a database that populates the invoice with information, and each invoice is attached to a separate box part of one order (15 boxes in one order) So the data is populates into the invoice with minor differences. I know its a pain for the minor differences, however, it benefits us in the long run. Thank you for the response !

+ 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. [SOLVED] How to automatically generate invoices for selected rows?
    By sebastiand95 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2019, 05:06 AM
  2. If function to generate 5 different invoices
    By Oeysbrei in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2017, 11:43 AM
  3. [SOLVED] Pulling information from sheet to help generate invoices
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2015, 08:12 PM
  4. [SOLVED] How to have a cell auto-generate text based on text from another cell?
    By wgilles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2015, 02:46 PM
  5. Replies: 0
    Last Post: 01-14-2013, 01:44 PM
  6. auto generate based on percentage?
    By tondrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 03:38 PM
  7. auto generate a comment box based on a cell value that has variable reference cells
    By vamedic11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2010, 06:56 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