ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Specify which rows to NOT hide, and have excel hide the rest (https://www.excelbanter.com/excel-programming/388094-specify-rows-not-hide-have-excel-hide-rest.html)

Mo2

Specify which rows to NOT hide, and have excel hide the rest
 
ok, before i start working on my excel sheet,
I'd like to specify in some how in some way,
(pop up window, or entering a number in a cell, it doesnt matter as long as
its "excel-newby-friendly")

A range of rows i wont be using, and have it hide those rows.
(or, preferrably, i'd like to specify which rows I WILL be using, and have
the script auto-hide the rest.)

In Column A, the cell values a "A-1" through "A-20"
after A-20, the next cell's value is "B-1" through "B-20", and so forth, up
to "O-1" through "O-20"

those cell values never changed. i use them to identify the rows in my sheet.

anyhow,
So before i start, the question is asked:
USING ROWS(to input data): A-1 through A- [x]
B-1 through B- [x]
C-1 through C- [x]
(and so on, up to
O-1 through O-[x]

The [x] indicates where i'd input a number
(if it can have a default number, like "2", that'd be awesome)

SUBMITTING this information would have excel HIDE every row not specified
within that 300 row range.

So... lets say i said
USING ROWS: A-1 through A-[5]
B-1 through B-[10]

This would make the rows with Cell's A-6 through A-20 HIDE, and rows with
cells B-11 through B-20 HIDE.
(Well, reastically, i'd also be specifying which of the "C- " , "D- ", etc ,
rows to also not hide...but i think you understand)

If it can't be done this way, i'm open to any other methods of accomplishing
this..
TIA


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com