Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Darin,
You can create Views of the same WS and switch between those. e.g Hide/show initial columns. ViewCustom ViewsAdd.. Give it a name. Repeat for each you require. Then have a button or some means to switch to the next view. NickHK "Darin Kramer" wrote in message ... Hi Guys, I have data within columns a to d which is static. From Columns e onwards to say az there is a variety of information which needs to be entered on a row by row basis. It is rather time consuming to write macros to hide and unhide columns depedning on the view required. Is there any easier way of group (ie viewing) columns? (eg I want to see columns a - d, and h - k, for purposes of data entry 1, and then to enter data set 2, I need to see A - d and m - q), and all others hidden). Kind Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming |