+ Reply to Thread
Results 1 to 2 of 2

Macro to print all invoices based on data entry page

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    1

    Macro to print all invoices based on data entry page

    I have a Data Entry page with 4 columns of relevant data. Property (starts with B8), Postage (..F8), Answering Service (..G8) & FedEx (..I8). I have an Invoice page that I want to have an invoice for each Property listed with the relevant data from columns F,G,I printed. I have a Print button with a macro that does not currently work. I pulled that from another source. Not sure if that macro needs to be corrected or another one created. I am a VBA/Macro novice. Any help is appreciated. The Property name should go in A8, Postage amount in C15, Ans Svc C16, FedEx C17 on the Invoice. File attached.
    Attached Files Attached Files

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to print all invoices based on data entry page

    Hi, bach7381,

    maybe like this?
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. Find Print Range and Print invoices from 250 tabs in Excel
    By Mr5holesinone in forum Excel General
    Replies: 4
    Last Post: 02-24-2014, 08:19 PM
  2. Replies: 3
    Last Post: 12-31-2012, 12:03 PM
  3. Macro to print page if data in specified cell
    By DGillham in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2008, 11:48 AM
  4. Macro to print the data from previous page
    By p007 in forum Excel General
    Replies: 2
    Last Post: 12-06-2007, 06:40 AM
  5. How to batch create / generate and print invoices from Excel data?
    By helenerz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2005, 10:05 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