Hi all
I would really appreciate any help on this. I want to design a worksheet to hidecolumns depending on the value of cell A1. I am guessing I would need to use VBA to do this, but I only started looking at VBA very recently so don’t know how to do this.
The columns will start from C and contain 151 different suppliers ending at EW, we need to enter loads of data for each supplier and hiding the columns will greatly help with this data entry<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Is it possible to have the VBA match the column heading against what is requested in A1 and hide all other columns?<o></o>
<o></o>
As far as I’m aware the other way would be write the VBA code for each column which would be a very long winded way for all 151 different suppliers
Just so you are aware I'm using Excel 2007
<o></o>
Looking forward for your response<o></o>
<o></o>
Ian
I would really appreciate any help on this. I want to design a worksheet to hidecolumns depending on the value of cell A1. I am guessing I would need to use VBA to do this, but I only started looking at VBA very recently so don’t know how to do this.
The columns will start from C and contain 151 different suppliers ending at EW, we need to enter loads of data for each supplier and hiding the columns will greatly help with this data entry<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Is it possible to have the VBA match the column heading against what is requested in A1 and hide all other columns?<o></o>
<o></o>
As far as I’m aware the other way would be write the VBA code for each column which would be a very long winded way for all 151 different suppliers
Just so you are aware I'm using Excel 2007
<o></o>
Looking forward for your response<o></o>
<o></o>
Ian