Hi,

I have a rush job for a church auction and I'm hoping someone can give me a
snippet of VB code that will show me what to do.

The auction items are in a worksheet. Each row contains the information for
an auction item. One of the columns is the Buyer ID. The Buyer ID
identifies the winner of each auction item. The worksheet will be sorted by
Buyer ID.

I want to run a macro that will print the auction items for each buyer. I
imagine a loop that will start at the top and print the auction items for
each buyer. Each buyer should have a separate printout.

Any ideas or examples? Thanks.

Hello,

I noticed that you have posted the question in
microsoft.public.excel.programming also. We will follow up you there. If
you have any more concerns on it, please feel free to post there. Thanks.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!From: "Hmmm..."
!Newsgroups: microsoft.public.excel.programming
!Subject: Printing
!Lines: 17
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
!Message-ID:
!Date: Fri, 23 Apr 2004 05:23:55 GMT
!NNTP-Posting-Host: 4.35.42.16
!X-Complaints-To:
!X-Trace: nwrddc03.gnilink.net 1082697835 4.35.42.16 (Fri, 23 Apr 2004
01:23:55 EDT)
!NNTP-Posting-Date: Fri, 23 Apr 2004 01:23:55 EDT
!Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.ash.giganews.c
om!nntp.giganews.com!cyclone1.gnilink.net!spamkill er.gnilink.net!gnilink.net
!nwrddc03.gnilink.net.POSTED!30ec6d2a!not-for-mail
!Xref: cpmsftngxa10.phx.gbl microsoft.public.excel.programming:492532
!X-Tomcat-NG: microsoft.public.excel.programming
!
!Hi,
!
!I have a rush job for a church auction and I'm hoping someone can give me a
!snippet of VB code that will show me what to do.
!
!The auction items are in a worksheet. Each row contains the information
for
!an auction item. One of the columns is the Buyer ID. The Buyer ID
!identifies the winner of each auction item. The worksheet will be sorted
by
!Buyer ID.
!
!I want to run a macro that will print the auction items for each buyer. I
!imagine a loop that will start at the top and print the auction items for
!each buyer. Each buyer should have a separate printout.
!
!Any ideas or examples? Thanks.
!
!
!

Hmmm does make things more complicated by posting
twice in the same programming newsgroup. <grin

Which is a typical problem of web based services, unless
steps are taken to prevent people from hitting ENTER twice.

"Yan-Hong Huang[MSFT]" wrote ...
I noticed that you have posted the question in
microsoft.public.excel.programming also. We will follow up you there. If
you have any more concerns on it, please feel free to post there. Thanks.