Select and copy multiple columns - but only the visible columns

[SteynBS]

Good day guys.

I have built a working sheet to ease single-column uploads - I want to progress to upload multiple columns but ignore blank or hidden ones.

The sheet works as follow:

Once the changes are entered into column C I have a vba that opens up a blank workbook and copies Columns (A5:C) with this code: Range("A5:C" & lr).Copy

Now I want to copy multiple columns but only the visible ones

Not all the columns will be utilized. for example maybe only Column C and E will be used. All the other columns except A,B,C,E needs to be copied. The others will be hidden manually (or if you have a suggestion other than manually hiding the columns not in use - I am all ears)

Please help me with a code to copy Column A,B and the orange colmns that will be in use

 

[shinigamilight]

I replicated your exact same setup by creating a table, adding command buttons and filtering the rows and hiding the columns. I still got the right result without altering the code. Maybe other people can help you.
You can download my workbook from the link below if you want to salvage something out of it.

Easyupload.io - Upload Files and Share Them Easily

Uplaod files easily and share them with your friends and colleagues. File upload solution for everyone. Upload big files and get a link to share effortlesly.

easyupload.io

 

[SteynBS]

I replicated your exact same setup by creating a table, adding command buttons and filtering the rows and hiding the columns. I still got the right result without altering the code. Maybe other people can help you.
You can download my workbook from the link below if you want to salvage something out of it.

Easyupload.io - Upload Files and Share Them Easily

Uplaod files easily and share them with your friends and colleagues. File upload solution for everyone. Upload big files and get a link to share effortlesly.

easyupload.io

I selected the range from the table header up to the last row - it caused the issue. I tried selecting the entire column from A to the last visible column and it worked.

Thank you for your assistance I really do appreciate your time and effort.

 

[shinigamilight]

Glad you figured it out.