Hi

I hope everyone is well.

I am working on a workbook in excel 2010 and need a bit of advice from someone who knows more than me (not hard that bit). I am doing the workbook for work, which contains several worksheets.

The top part of each worksheet contains generic information including a few simple formulas which are relevant to all sites, the bottom part will be specific for each site (there are 7 sites) and each site will need to filll that bit in. As such there will be more than 1 workbook each sharing the same information whilst at the same time, each will have their own specific information as well.

I will need to update the generic bits now and again and can see this being a pain as I would have to change 7 or 8 workbooks each time. Is there anyway round this? Ideally I would like to link them together so that I can change my bit in my master file and the other workbooks would then change automatically whilst maintaining their site specific bits.

Could anyone advise please? I can sit them spreadsheets on the central networks so there is no issue there.


Thanks


Noyman