Macro code

[markster]

Basically, I have a spreadsheet. I need some macro code (that I can easily edit to create different reports from it). The reports will basically be to print all data contained in certain columns. For instance the first one I want to create will print all data in columns B, D, F G and H. The only issue is that I need a filter/dialogue box to pop up so I can choose which department to print the information for i.e. Department A, B, C D or All ) this data is held in column F (kind of like what happens when you filter). Can anyone help?

Hope this makes sense.

Cheers guys

Mark

 

[Fazza]

Hi Mark. I don't 100% understand the requirement. Though it sounds like you might be able to use Excel's custom views functionality to do this. In Excel 2003 it is under menu view, custom views. HTH, Fazza

 

[Smitty]

Have you tried the macro recorder?