I have a summary sheet that has a vlookup that pulls back data from another sheet. The formula works very well however when I use my drop down to change the value the vlookup it pulls back data of different length, so every I have to adjust the column width of my summary sheet. Can some one please help me with a marco that adjusts the width of columns. I could use the macro recorder but when I do it sets itself for the length of the current summary and I need something that can fluctuate with the different lengths.
Thank you in advance.