LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Vlookup and print loop

Hi,

I have a sheet that uses a lookup table to fill in values the sheet is then
printed.

I would like to loop the sheet so that I am able to print several sheets if
needed, I thought the best way to achieve this would be to add a checkbox
next to each record, where there is tick (true) that record needs to be
printed, - is this possible?

Sheet1 - page to be printed dropdown list located at cell a14 which looks up
the value on sheet2 column A

Sheet2 - contains the lookup table

A B C D
E F G (checkbox with link
to cell - true/false)

a001 something something something something
something checkbox (True/False)
a002 something something something something
something checkbox (True/False)
a003 something something something something
something checkbox (True/False)
a004 something something something something
something checkbox (True/False)
a005 something something something something
something checkbox (True/False)
etc

Thanks in advance!

 
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
simple print loop crashes Ken Excel Programming 3 August 5th 08 08:34 PM
print preview in loop CG Rosen Excel Programming 1 June 9th 08 01:49 AM
Excel print loop [email protected] Excel Programming 3 November 22nd 06 09:49 PM
Macro for Print Loop within Excel Browner[_4_] Excel Programming 3 May 18th 06 01:22 PM
How do you Print with a loop? rohrl77 Excel Programming 3 June 14th 05 09:10 AM


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

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

About Us

"It's about Microsoft Excel"