S
sanjay_suda
Hello Good People,
I have a very large spreadsheet with approx 35 columns and over 50
rows. However, I do not need to see all the rows at any point in tim
and may want to look at just a limited number of rows. Generally I nee
to look at only those rows that have a non zero value in a specifi
column. Such rows can be randomly dispersed within the spreadsheet.
I can use the option of sorting the full spreadsheet based upon th
value of the cells in the particular column, however, this does no
help very much as I would need to do this every time I referred to th
sheet - which may be upto 20 times a day (the sheet is populate
automatically from a database every 15 minutes).
If possible I would like the rows to hide and unhide themselve
automatically based upon a condition like If value in a specifie
column is non zero then hide the row. This will also allow me to retai
the original sort order of the rows which is based upon differen
columns.
Is this possible.
Regards and Thanks for Assistanc
I have a very large spreadsheet with approx 35 columns and over 50
rows. However, I do not need to see all the rows at any point in tim
and may want to look at just a limited number of rows. Generally I nee
to look at only those rows that have a non zero value in a specifi
column. Such rows can be randomly dispersed within the spreadsheet.
I can use the option of sorting the full spreadsheet based upon th
value of the cells in the particular column, however, this does no
help very much as I would need to do this every time I referred to th
sheet - which may be upto 20 times a day (the sheet is populate
automatically from a database every 15 minutes).
If possible I would like the rows to hide and unhide themselve
automatically based upon a condition like If value in a specifie
column is non zero then hide the row. This will also allow me to retai
the original sort order of the rows which is based upon differen
columns.
Is this possible.
Regards and Thanks for Assistanc