Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fred
 
Posts: n/a
Default How to print invoices for each advertiser from Excel worksheet

I set up a worksheet which lists Publication Date, Account Rep, Advertiser,
Client ID, Columns, Inches, Price for newspaper advertisements. And what I
want to do is merge this information the day after publication into an
invoice format so that all that I have to do is command print invoices for a
certain day and Excel will print an individual invoice for each advertiser
listing the size of ad, color, and price. Thanks in advance for your help!
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"Fred" wrote in message
...
I set up a worksheet which lists Publication Date, Account Rep,

Advertiser,
Client ID, Columns, Inches, Price for newspaper advertisements. And what

I
want to do is merge this information the day after publication into an
invoice format so that all that I have to do is command print invoices for

a
certain day and Excel will print an individual invoice for each advertiser
listing the size of ad, color, and price. Thanks in advance for your

help!

So the first thing you need to do is set up your invoice format. Many would
suggest designing your invoice in Word, then doing a mailmerge with the
Excel table as the datasource. But you can do your invoice as a separate
worksheet in the same workbook, then use a macro to send the values from a
job record (row) to the invoice sheet if required (ie: if publication date =
whatever).

In its simplest form, the macro to process a single job record would look
like:

Sub Do_Invoice()
Range("Invoice!B2") = ActiveCell
Range("Invoice!B4") = ActiveCell.Offset(0, 1)
Sheets("Invoice").PrintOut Copies:=1
End Sub

, ie: send the value from the current cell (pub_date) to B2 on Invoice, then
send the value from the next cell (zero rows down, one column across) to B4
on Invoice, then print Invoice.

From there, you'd just need a code loop to process all the records (if
pub_date = OK, run the code, move to next job record & do it again ; if not,
*just* move to next job record and do it again.

HTH,
Andy


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
EXCEL - Cannot print borders in color(s) I have selected Mark M Excel Discussion (Misc queries) 0 January 18th 05 04:25 PM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 08:14 PM
command button in excel will move when print. [email protected] Excel Discussion (Misc queries) 1 December 29th 04 04:53 PM
Microsoft Excel could not find anything to print cyndi Excel Discussion (Misc queries) 1 December 22nd 04 02:40 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"