Dec 14 2019 05:25 AM
I have built an Excel sheet with roughly 30 columns that pull data from the web. I want to be able to pick a certain number of these columns randomly and easily so I can see the selected columns on one screen. What is the best way to create this? i.e. Today I might want to look at 4 columns of the 30 but I don't want all 30 current columns on my view screen because it's too difficult to visually see. A week later I might want to view 6 different columns from the 30 columns. Do I need to start working with VB or is there a better way to do this.
Dec 14 2019 05:44 AM
SolutionWhy doesn't Hide columns work with you?
Dec 14 2019 05:48 AM
That is a good question and I can hide columns. I was just wondering if there was another way to pull this data to possibly a new sheet or new view once I selected the columns I was looking for. You may be right that hiding the columns is the simplest way.
Dec 14 2019 05:44 AM
Solution