View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Selecting From a Choice for Printing Out

yes, this is possible.
the "reproduced on another excel sheet" is easy - the "exported to
Word" is harder. doing this in Word would be harder to code because
you can't have different worksheets as in excel.

you'd have to start by creating a userform with checkboxes for each of
your sheets/ranges of data.
search the newsgroup for userforms (or the internet for excel
userforms) to get you started.
hth
susan



On Mar 25, 4:50 am, Iain Scott wrote:
Hello,

Can this be done in Excel?

A large list of options are created from which I'd only select a few.

These few only are then reproduced on a second spreadsheet for
printing and/or exported to WORD.

example ...

"client has a"
"client has b"
"client has c"
"client has d"
"client has e"

... if I select only b and e, say, then the two complete statement of
b and e are then duplicated on another spreadsheet or made exportable
to WORD.

The selections could be in the form of tickboxes or whatever is best
appropriate to mark quickly.

Is this possible? I have tried it in WORD and got nowhere.

Cheers!

Iain Scott