User Choosing Which Columns to View

C

Colin Vicary

Hi All

Google has failed me (probably because I asked the wrong questions!)

I have a ss with around 100 columns.

I want the user to be able to view only selected columns by (ideally)
showing a list of all available columns and the user then "ticking"
which ones they want to see.

If it were possible to, say, put a number against each column they
wanted and the resulting spreadsheet had the columns in the order
they'd chosen, I'd probably be the most popular guy around - for a few
days.

Hope you can help

Colin
 
B

Bob Phillips

Here is a different way of doing it

Sub HideColumns()
Dim rngCols As Range

Set rngCols = Application.InputBox("Use the mouse to select the columns
to hide (ctrl-click for seconf etc.)", Type:=8)
If Not rngCols Is Nothing Then
rngCols.EntireColumn.Hidden = True
End If
End Sub


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Colin Vicary" <[email protected]>
wrote in message
news:[email protected]...
 
C

CLR

If you only have a few options, like the Purchasing Dept always wants to see
the columns they want, and Shipping always wants some of the same but some
different, etc etc. then you could set up a MainSheet with macros thereon to
just hide the unwanted columns and show the desired ones........just one push
of a button........

hth
Vaya con Dios,
Chuck, CABGx3
 
C

Colin Vicary

Thanks for those guys, but it's not really what I'm after.

I have a dos function that takes a list of product codes and adds
around 100 pieces of information to a csv.

Most of the standard requests for info are set up by simple macros.

What I'm trying to do is deal with the less frequent requests.

I'd like to have a sheet where all the available fields are in column
A, the user then picks which ones they want by ticking column B - then
the macro goes off and brings back just those columns.

I would adapt your answers to add extra functionality; if the user
chooses to see sales for months Jan to Jun 2005, I could then just show
the summed sales af those months.

Thanks again

Colin
 
Top