View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MM User MM User is offline
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!