Unhide row directly below

**jimbean** · 01-09-2009, 01:13 PM

Hi,

I was wondering if it's possible to unhide a row directly below one that is visible?

I am creating a template for users that allows them to choose which lines (rows) they would like to use. They then hit a button to hide all the other lines they don't wish to use.

For each row that is visible I then need the row directly below it to become visible so that the user can enter associated information.

I'm stumped on how to do it. I have the user entering "a" in column A for any row they wish to keep - but I'm not sure how to incorporate this into unhiding the row below (or if I'm on the wrong track with my thinking).

Thanks for your help!

Jimbean

**royUK** · 01-09-2009, 01:17 PM

Attach the workbook with your ode so far.

**jimbean** · 01-09-2009, 01:38 PM

Here's what I have so far

the finished product will have all the rows with "TWE - Costs" hidden, when the user puts the a (checkmark) in column A; the corresponding TWE - Costs will appear and all other rows will be hidden.