I am new to VBA codes. I have a worksheet where column A data changes between “Hide” and “Show” when you select a different drop down option (ex – 1-8). I am wanting to show the number of lines selected from a drop down box for each individual data set of 8 rows for data set 1 and a further 8 rows for data set 2. E.g. I want to show the first 4 lines of data set 1 and the 3 lines from data set 2.
I have tried the below code which works for the first data set (and I didn’t need to add column A to have Show or Hide appear depending on the drop down value), however I couldn’t get it to work for the second data set as I don’t know how to add multiple macros (and it seems a bit long winded for the code).
I have tried the below code which works for the first data set (and I didn’t need to add column A to have Show or Hide appear depending on the drop down value), however I couldn’t get it to work for the second data set as I don’t know how to add multiple macros (and it seems a bit long winded for the code).