U_Shrestha
05-14-2008, 12:04 PM
Hi all,
In my attached sheet, I need to hide the empty columns for proper viewing and printing the table. The way it works is, I enter a station number in B3 and the rest of the data fills up the table based on the value in B3. In this process, no. of columns utilized varies based on the value in B3, e.g Station No. 54 may have 10 tanks and station 55 can have 5 tanks. What I am looking for is as soon as I enter Station No. in B3, I want to hide the non-used columns, for proper viewing and printing. I don't want to print the empty columns as it takes up space. I would appreciate if somebody can help me with a code. Thanks.
In my attached sheet, I need to hide the empty columns for proper viewing and printing the table. The way it works is, I enter a station number in B3 and the rest of the data fills up the table based on the value in B3. In this process, no. of columns utilized varies based on the value in B3, e.g Station No. 54 may have 10 tanks and station 55 can have 5 tanks. What I am looking for is as soon as I enter Station No. in B3, I want to hide the non-used columns, for proper viewing and printing. I don't want to print the empty columns as it takes up space. I would appreciate if somebody can help me with a code. Thanks.