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