Numataghvy80

How To Edit A Drop Down List In Excel Youtube  Sub PrintAll() Dim wb as Workbook, cell as Range Set Wb = ActiveWorkbook 'or ThisWorkBook if the code is in your reporting workbook For Each cell In Select the columns you want to have in your sheet and unclick the option Use original column name as prefix Press OK Finally, you will get the combined data of the three Select option in excel sheet