Group the two sheets and then apply the actions - they will occur on
both sheets. Then ungroup the sheets at the end.

To group the sheets, select Sheet1, hold the CTRL key and click on the
tab for Sheet2, then release CTRL. Now everything that you do in
Sheet1 will be reflected in Sheet2, so you can insert a new column D
and put a heading in D2 and this will be duplicated in the other
sheet(s).

To ungroup the sheets just right-click on one of the sheet tabs and
select Ungroup Sheets from the drop-down.

Hope this helps.

Pete

On Oct 3, 12:40*pm, Ken wrote:
How do I insert a column in “sheet1” and then automatically have the same
column added into “sheet 2”
Columns in “sheet 1” and “sheet 2” will have the same name.
I would like to add the column in-between “C” & “D” on “sheet 1 and fill in
a heading in cell in what will now be “D2” and them have the same happen in
“Sheet 2” without having to go “sheet 2” and repeating the process manually