| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding column if cell in previous column is empty-revised
The problem I have is that I have 10 years worth of data for 71 items
in 10 columns and 71 rows.I then have 20 empty columns after those awaiting data entry (for the next 20 years). I was wondering if it was possible to hide all columns not in use, leaving only one empty column at the end of the entered data. When a specified cell is filled in, I want the next empty column to be unhidden so that there is always one empty column. Thank you very much in advance if you can help!!! Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill in empty cells with previous entry in column | Excel Discussion (Misc queries) | |||
| Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
| Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| Copying a formula in a blank column as far as data in previous column | Excel Programming | |||
Threaded Mode
