Forum Discussion
Copying connected sheets
Click on the first of the two sheet tabs.
Hold down Ctrl while you click on the second of the two sheet tabs.
You have now selected both sheets.
Option 1: Drag one of the selected sheet tabs to the right (the other will come with it). Before you drop it, press and hold Ctrl.
Option 2: Right-click any of the selected sheet tabs.
Select 'Move or Copy' from the context menu.
Tick the check box 'Create a copy'.
Select '(move to end)' in the 'Before sheet' list box.
Click OK.
Both options will copy both sheets, and adjust the formulas linking them correctly.
Important: before you enter anything in the copied sheets, either click on another sheet tab, or right-click on one of the selected sheet tabs, then select 'Ungroup sheets' from the context menu.
If you forget to do that, anything you enter will be entered on both sheets at the same time.
Click on the first of the two sheet tabs.
Hold down Ctrl while you click on the second of the two sheet tabs.
You have now selected both sheets.
Option 1: Drag one of the selected sheet tabs to the right (the other will come with it). Before you drop it, press and hold Ctrl.
Option 2: Right-click any of the selected sheet tabs.
Select 'Move or Copy' from the context menu.
Tick the check box 'Create a copy'.
Select '(move to end)' in the 'Before sheet' list box.
Click OK.
Both options will copy both sheets, and adjust the formulas linking them correctly.
Important: before you enter anything in the copied sheets, either click on another sheet tab, or right-click on one of the selected sheet tabs, then select 'Ungroup sheets' from the context menu.
If you forget to do that, anything you enter will be entered on both sheets at the same time.
This worked perfectly - I used option 2. Thank you so much again!