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