tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I thought this would be easy but struggling as I've got set ranges I want this to work in.
So lets explain the concept first,
I have 4 areas in my document that people fill out, to save space on the sheet I hide the rows not being used as there is a lot of row that will be blank,
for example F10-F20 are for out of stock Items, now I might not have any out of stock item's but I'm likely to have some, I've look at the past and never had more than 10 so I dedicate 10 Rows to out of stock items,
below that I have Back orders,
Now Back orders can be a lot so I've given 20 Rows to that F25-F45.
Now if you can picture the sheet without any Out of stock Items or Back orders I have Rows F10 - F45 taking up room so you have to scroll down to them and below, but I don't need empty rows show so I hide F11-F20 and F26-F45 etc. so now I have a much more condensed page, with just one row on show for Out of Stock and one for Back orders,
so I need a way to hide / unhide these hidden rows if data is added?
so if F10 is on show if data is added to F10 the F11 unhides F11 then F12 etc, however if I delete the data in f12 I want the row to hide again.
heres a bit more detail.
So I have 4 ranges all in the same column "F"
they are F10-F20, F25-F45,F51-F56, F70-F99.
now each of these ranges starts of as a hidden except the first row so F10,F25,F51,F70 are all unhidden, the rest are hidden.
all I want is a macro that when you add data into the row above in the range it unhides the row below,
So F10 is empty, if I add data into F10, F11 becomes available down to F19 with F20 being the last one, however if you delete the data from the cell the cell you deleted from hides except F10 etc that are always visible,
please help
Tony
I thought this would be easy but struggling as I've got set ranges I want this to work in.
So lets explain the concept first,
I have 4 areas in my document that people fill out, to save space on the sheet I hide the rows not being used as there is a lot of row that will be blank,
for example F10-F20 are for out of stock Items, now I might not have any out of stock item's but I'm likely to have some, I've look at the past and never had more than 10 so I dedicate 10 Rows to out of stock items,
below that I have Back orders,
Now Back orders can be a lot so I've given 20 Rows to that F25-F45.
Now if you can picture the sheet without any Out of stock Items or Back orders I have Rows F10 - F45 taking up room so you have to scroll down to them and below, but I don't need empty rows show so I hide F11-F20 and F26-F45 etc. so now I have a much more condensed page, with just one row on show for Out of Stock and one for Back orders,
so I need a way to hide / unhide these hidden rows if data is added?
so if F10 is on show if data is added to F10 the F11 unhides F11 then F12 etc, however if I delete the data in f12 I want the row to hide again.
heres a bit more detail.
So I have 4 ranges all in the same column "F"
they are F10-F20, F25-F45,F51-F56, F70-F99.
now each of these ranges starts of as a hidden except the first row so F10,F25,F51,F70 are all unhidden, the rest are hidden.
all I want is a macro that when you add data into the row above in the range it unhides the row below,
So F10 is empty, if I add data into F10, F11 becomes available down to F19 with F20 being the last one, however if you delete the data from the cell the cell you deleted from hides except F10 etc that are always visible,
please help
Tony