How To Make an Excel Sheet Equal to AnotherSolved/Closed

Question

Hi, I'm new in Excel, and what I'm trying to do is this:
I want to make an entire sheet equal to another, except for one cell, so if I change something in my main sheet the changes are made in all the other sheets automatically, but there is one cell in each sheet that I want to manually enter some data, I'm not sure if that's even possible, but I had to ask :P

TrowaD · Answer

Hi AML,

 First select all sheets: right-click a sheets tab and choose the option to select all sheets.
 Exclude your main sheet: left-click main sheets tab while holding the CTRL key (make sure the main sheet isn't the active sheet).
 Apply formula: Select cell A1 and type: =IF(Main Sheet!A1="","",Main Sheet!A1)
 Apply formula to rest of the cells: Select cell A1, left-click and hold the bottom right corner of cell A1. Drag it to the right as far as needed. Now drag row 1 down as far as needed.
 Exclude the one cell: Select the one cell and hit delete to remove the formula.

Now left-click the main sheets tab to cancel sheets group and check to see if you got what you wanted.

Best regards,
Trowa

How To Make an Excel Sheet Equal to Another

1 reply

Similar discussions

Subscribe To Our Newsletter!