tharindudk
01-29-2014, 06:40 PM
Hi,
I have created a worksheet where I enter number of sites and using a Template in Sheet 2, Column E, this template get copied to next empty columns.
That is, If I enter 3 in No of Store sheet 1, In sheet 2, Columns F, G and H get created using the Template in Column E.
The problem I have is, I am hiding dows depending on the selection from drop down lists. When this is the case, I want to hide rows of columns individualy, but I have written the code to hide rows based on Cell Names used in Column E.
Is there a way to hide unhide cells as required when I create a column. I know If I manualy rename the Cells, it will work, but instead what if every time a column get gopied, rename the cells to Clothes_type_1, Clothes_type_2, Clothes_type-3 since original name of the Cell is "Clothes_type".
Also instead of hiding, crossing out is also fine.
I have made a simple template and attached it here. any help is appriciated.
I have created a worksheet where I enter number of sites and using a Template in Sheet 2, Column E, this template get copied to next empty columns.
That is, If I enter 3 in No of Store sheet 1, In sheet 2, Columns F, G and H get created using the Template in Column E.
The problem I have is, I am hiding dows depending on the selection from drop down lists. When this is the case, I want to hide rows of columns individualy, but I have written the code to hide rows based on Cell Names used in Column E.
Is there a way to hide unhide cells as required when I create a column. I know If I manualy rename the Cells, it will work, but instead what if every time a column get gopied, rename the cells to Clothes_type_1, Clothes_type_2, Clothes_type-3 since original name of the Cell is "Clothes_type".
Also instead of hiding, crossing out is also fine.
I have made a simple template and attached it here. any help is appriciated.