- Joined
- Jul 18, 2012
- Messages
- 1
- Reaction score
- 0
Hello everyone,
My apologies for making my first post a question without a proper introduction.
I'm Biffa and have gratefully browsed your forums and had valuable help in the past. Thank you all.
I have an excel document of which i hope to attach a simplified version to this thread.
It normally runs some VBA, and I recently altered it so that when we fill a form in (not attached) it automatically has a lot of data filled in (in columns M:AE). This seemed easier than clicking dozens of drop downs for every entry.
The ECN database holds all the information. However, because I have auto filled a load of data, it shows up in columns M to AE.
These columns relate to different products e.g Columns M to AA relate to PRODUCT A
Columns AB to AC relate to PRODUCT B
Columns AD to AE relate to PRODUCT PLUS
I did manage to auto hide the columns, but couldnt get them to re-open.
I'd like to autohide them all the time. If a product is selected by filter in column D PRODUCT FAMILY i need it to show the corresponding columns for that product.
I hope i made this clear enough.
Thanks in advance
Biffa
My apologies for making my first post a question without a proper introduction.
I'm Biffa and have gratefully browsed your forums and had valuable help in the past. Thank you all.
I have an excel document of which i hope to attach a simplified version to this thread.
It normally runs some VBA, and I recently altered it so that when we fill a form in (not attached) it automatically has a lot of data filled in (in columns M:AE). This seemed easier than clicking dozens of drop downs for every entry.
The ECN database holds all the information. However, because I have auto filled a load of data, it shows up in columns M to AE.
These columns relate to different products e.g Columns M to AA relate to PRODUCT A
Columns AB to AC relate to PRODUCT B
Columns AD to AE relate to PRODUCT PLUS
I did manage to auto hide the columns, but couldnt get them to re-open.
I'd like to autohide them all the time. If a product is selected by filter in column D PRODUCT FAMILY i need it to show the corresponding columns for that product.
I hope i made this clear enough.
Thanks in advance
Biffa