+ Reply to Thread
Results 1 to 3 of 3

Taking data from a data sheet to print out on every page of the invoice

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    Đan Mạch
    MS-Off Ver
    2010
    Posts
    21

    Taking data from a data sheet to print out on every page of the invoice

    Hi guys

    I have a 'Data sheet', where I keep tracks of all items and quantities. I have another sheet 'Print sheet', where I design the layout to print out the items as an invoice. Please see the photo below. The problem I am facing is I have to keep the company's info in every invoices and only change the data according to the order number.

    Annotation 2019-12-12 085130.png

    Therefore, is there any way that I print out the first invoice then the excel will take data from the next order number from the 'Data sheet' and insert it in the print sheet so I can the second invoice and so on.

    Or the purpose is I can print out all the invoices with their information without having to copy all the company info again and again.

    Thanks guys

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Taking data from a data sheet to print out on every page of the invoice

    Pictures are of little value.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Taking data from a data sheet to print out on every page of the invoice

    Hi Lan Tran
    do all the invoices have exactly 3 lines of items? as you show in your example,
    or they may have 1, ...3....10... any amount of lines of items.
    Barriers are there for those who don't want to dream

+ 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. Replies: 1
    Last Post: 11-15-2019, 02:57 AM
  2. Print invoice based on data entered in to a section on another sheet
    By internalglitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2014, 07:58 AM
  3. [SOLVED] Macros Print multiple invoice Generator 2 different customers per single page Odd/Even num
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-25-2013, 11:20 PM
  4. [SOLVED] Taking data from a data log sheet and populating that data on another
    By jamalfried in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2013, 10:56 AM
  5. Replies: 3
    Last Post: 09-14-2013, 06:54 PM
  6. Replies: 9
    Last Post: 04-04-2011, 12:03 AM

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