ExcelBanter - Unhiding rows based on data input

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Unhiding rows based on data input (https://www.excelbanter.com/excel-discussion-misc-queries/209525-unhiding-rows-based-data-input.html)

Janelle S[_2_]

Unhiding rows based on data input

Is there any way to unhide a number of rows based on the number that the user
inputs. Eg. if user inputs 4 into cell p48 then i would like the 4 rows
immediately below row 55 to unhide.
Thanks in anticipation.

Argy - Arcasoft

Unhiding rows based on data input

Hi Janelle. Yes there is a way, but you need macros VB for this. Any
experience?

"Janelle S" wrote:

Is there any way to unhide a number of rows based on the number that the user
inputs. Eg. if user inputs 4 into cell p48 then i would like the 4 rows
immediately below row 55 to unhide.
Thanks in anticipation.

Janelle S[_2_]

Unhiding rows based on data input

Thanks Argy. Some experience, mostly through help via these posts. Any help
you could give would be greatly appreciated.

"Argy - Arcasoft" wrote:

Hi Janelle. Yes there is a way, but you need macros VB for this. Any
experience?

"Janelle S" wrote:

Is there any way to unhide a number of rows based on the number that the user
inputs. Eg. if user inputs 4 into cell p48 then i would like the 4 rows
immediately below row 55 to unhide.
Thanks in anticipation.

All times are GMT +1. The time now is 10:26 AM.