Sharing Workbook

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

Can you just reference the cells on the other sheets to the cells on the first sheet? That way, when you change the contents of the cells containing the generic bits on the first sheet, the cells on the other sheets will pull the cell contents from the first sheet.

To reference a cell in a different sheet: http://www.homeandlearn.co.uk/excel2...l2007s8p7.html

Jester / Richard

Thanks for the posts.

Richard

How do I link them? I know it is a daft question, but not everyone from Stockton Heath is good with excel (I kid not, to prove it Egos, London Bridge, St Roccos Charity Shop).

Thanks

noyman,

How do I link them?

You can link them by basically typing an equal sign "=" into the cell, and clicking on the cell that contains the information you want to reference. Or you could view the link I posted earlier.

Folks


Thanks to you both for your help, now I know I will do it, it will help greatly and make the process more manageable.


Richard

I see the old curry house in the village above the post office has now turned into a burger place! Just what we need, another place to eat. I was gutted when the kebab shop shut!


Thanks once again.


Noyman