Unhide columns based on the previous column's value

Hi guys

i am new to this and am really struggling. i cant seem to find help for my specific problem on any site.

i have a sheet with various comments columns, labelled comment 1 to comment 20. they are in colummn S to AL. we only want a column to show if the previous column has data in it. ie comment 2 will only be available if someone writes under comment 1.

the length of the rows is about 1 000

ant suggestions?

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

One question - even if there is 1 comment in the entire column T for example, you want column U to be unhidden?

yeh, essentially that is the idea. I have come up with the below code. it works fine, and i have just repeated it for each column. i'm sure there is an easier way then repeating it, but this works for now for the code. i'm not sure if any of yuo are fimiliar with TM1, but when i save the document on TM1, it wont load anymore. it wont accept the excel format, so that defeated the purpose of my idea.

Please Login or Register  to view this content.

thanks for your help guys,
cheers

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

Be right back with a solution.