Thread: I need Help duplicating selected columns from a master job sheet to a new sheet

I need select columns to be duplicated (including formatting) on a new sheet in the same worksheet. I need it to automatically update the Followup sheet when I make changes to the Master sheet.(including inserting new rows) I currently have tried Lookup formula and grouping sheets. lookup worked to duplicate the data but would not copy a inserted row... Thanks in advance for looking into this! I have attached the file. I want to duplicate Columns:A, G, and J thanks again!BID SCHEDULE December.xlsx

Hi,

If you just want to keep a back up of data, you can use a macro instead of running into complex formulas. You can use the following macro, it will back up your data. I've assigned a keyboard shortcut key "CTRL+Q to execute this macro in your sheet.
All you have to do is update your master sheet and press "CTRL+Q" and this will copy the selected columns to follow up sheet. You can insert rows,change format everything wil be copied as it is.

Sub Macro1()
'
' Macro1 Macro
'
'
Range("A6:A500").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DECEMBER FOLLOW-UP").Select
Range("A6:A500").Select
ActiveSheet.Paste
Sheets("DECEMBER BID FILE").Select
Range("G6:G500").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DECEMBER FOLLOW-UP").Select
Range("B6:B500").Select
ActiveSheet.Paste
Sheets("DECEMBER BID FILE").Select
Range("J6:J500").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DECEMBER FOLLOW-UP").Select
Range("C6:C500").Select
ActiveSheet.Paste
Sheets("DECEMBER BID FILE").Select
Range("A6").Select
End Sub


Hope this helps.

Warm regards
Ishtiyaq

Thanks for your help I"ll try it and see how that works!

will this work if I want it to be copied on a different workbook? this example shows it on the same workbook.