View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default HELP! - Printing a sheet with values populated from dropdown b

So work from the list that you use as the source of the validation dropdown.

--
Regards,
Tom Ogilvy

"Co-op Bank" wrote in message
...
Sorry its from a validation drop down box. cheers

"Tom Ogilvy" wrote:

Is the dropdown box from an autofilter? If so, there is no way to

access
that list. You can build a list you can loop through by using the

Advanced
filter with the unique option.

If it is from data validation, then just use the source data you used to
populate the list.

--
Regards,
Tom Ogilvy

"Co-op Bank" wrote in message
...
Hello,

I have a frustrating problem, I have a dropdown box in Excel which

holds
around 1,000 numbers (cost centres). When I select a number the values

on
the
spreadsheet change to those respective to the selected cost centre

(i.e.
sales £, volume).

What I would like is a macro to loop through every cost centre in the
dropdown box and print for all 1,000 selections in the dropdown. Is

this
possible? Otherwise i'd have to go through them all one by one to

print
them
off.

Any help much appreciated. Regards Brian Taylor, Co-op Bank,

Manchester,
UK