Excel auto update cells

Hi all, first time poster so be gentle.

I'm hoping you may be able to help.

I currently have a excel document that requires some forms of repetition (see attached image). I'm wondering if it's possible that if a cell is updated it also updates other cells, rather than having to copy and paste a lot of times. If you notice on the image that say for instance there is one row of prices for 8700k, well I'm hoping it's possible that if I place a new price in one of the cells it will update all the other cells on that horizontal line.

Capture.JPG

So if I updated B90 it would automatically update B104 and so on.

Any advice and assistance is appreciated.

sure, just type =B90 in B104 and every time B90 changes, B104 also changes to that value.

For your second post.. always attach an example file and not an image.. this is the excel forum not the photoshop forum..
Makes a lot easier for us to show you the solution. an excel file says more than a 1000 words (or pictures)

Thanks for the swift reply.

I didn't release it was that easy.

Is there anyway to do this on a larger scale as I have about 10 separate builds that use most of the same parts so rather than having to type the details horizontally and vertically I can just write a 'forumula' to do it for me?

Also is there anyway to do it whilst keeping the formatting for instance if B90 is green in colour is there a way to place B104 as the same colour?

Thanks in advance.

To do on a larger scale just type in B104 the =B90
then copy the cell B104
Select the whole area with your mouse
choose paste
That will take care of linking the values, each cell will have the reference to its own counterpart so C104 will have = C90 and K120 will have =K96

To also have the formatting of the above range.
Select B89:K96 and copy

Then select the paste range with your mouse
Goto paste special in the dropdown of paste special and select paste formatting

if you have conditional formatting setup instead of regular cell color then
choose in paste special the last option in the rightside row of radio buttons "All merging conditional formats