Hi Im new here, hoping to learn a lot about VBA
I would like to create a command button code that will pop-up a list box listing all the sheets present in the workbook.
For each selected sheet in the list box it will copy a specific column on selected sheet in listbox, and paste to a new sheet to a diffrent column
I have Sheets - 'Block A', 'Block B', 'Block C', 'Block D'
Press button - Listbox pop-up including all the present sheet in the book
Select in list box - 'Block A', 'Block B', 'Block D' only
Column to copy for each - C:C
New Sheet to be generated - 'Building A'
Now Each Column C:C copied will be pasted to Sheet 'Building A' on different column with interval of 2 columns each
so it will look like
Building A Sheet's:
Column A - contains Column C:C of Block A
Column D - contains Column C:C of Block B
Column G - contains Column C:C of Block D
...and so on depending on number of sheets ticked in the list box.