Find, Copy and Insert Copied Column

Hi All,

I have a sheet with multiple columns. There are also multiple sheets in this doc.
Via a button, I want to go to to find a particluar sheet, called "DCRP", then in that sheet i want to find one of the columns called "template", then copy this column and insert the copied column just before the Template column.

Can someone help me with this.

Thanks.

Hello Kojack75,

Welcome to the Excel Forum. Here is a macro to that will find the column "template" on the worksheet "DCRP", insert a column to the left of "template", and copy the "template" column into it.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel

To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

Thanks, that worked perfect