Help

  • Thread starter Thread starter jdorion
  • Start date Start date
J

jdorion

Hello

I was wondering if anyone could help me. I have made a receiving log
for different suppliers. The first two lines is the same in all the
sheets. What I have done is make one workbook with 30 different sheets
each one being a supplier and the first one being a master sheet. Is
there any way to make it so if I change anything on the master sheet it
will change on the other sheets. The only thing is that I don't want
all the information to change just the two first lines.

Thank you and have a great day

Jessica
 
jdorion said:
Hello

I was wondering if anyone could help me. I have made a receiving log
for different suppliers. The first two lines is the same in all the
sheets. What I have done is make one workbook with 30 different sheets
each one being a supplier and the first one being a master sheet. Is
there any way to make it so if I change anything on the master sheet it
will change on the other sheets. The only thing is that I don't want
all the information to change just the two first lines.

Thank you and have a great day

Jessica
Click to expand...

I assume that you have entered the same data on the first two rows into all
30 sheets. Instead, you should just have this data on the master sheet
(Sheet1). On all the others, you should have formulas referencing Sheet1. To
do this quickly, group all sheets except Sheet1 (by clicking the tab of
Sheet2 and then holding down SHIFT whilst clicking the tab of the last
sheet. You will now be viewing Sheet2, but everything you do will be done to
all grouped sheets. Select A1 and type in the formula
=Sheet1!A1
Then copy this cell and paste over the required cells in the first two
rows - say A1:H2.
Next ungroup the worksheets by right-clicking the tab of any one and using
"Ungroup sheets".

Now whenever you change anything in rows 1 or 2 of Sheet1, the same will
appear on all other sheets.
 
If all your sheets have identical first two lines, all you have to do is to
hold down the CTRL key and select the sheet tabs at the bottom of the
screen. Make your changes on the first page and all selected pages will
change at the same time.
 
Back
Top