Excel help

[Ouroboros]

i have a spreadsheet 5000 odd sites, with information and some information that i add in, some remains static.

Now the information is assigned to sites who need updates etc.

Is there a way to create tabs per site that update the main sheet, but also pull information to it.

i can only think of using = for some sites, but it would require loads of manual work.

[FunkyGibbon]

This VBA code

https://www.extendoffice.com/documents/excel/1174-...

will help you split the master sheet to individual ones.

However, if you want 2 way linking between master and child sheets, you would be much better off using a database like Access IMHO

Plenty of online tutorials about how to go about this.

[paulrockliffe]

Or putting the source data into Power Query and Power Pivot and keeping your relational model in Excel.

[Planet Claire]

paulrockliffe said:

Or putting the source data into Power Query and Power Pivot and keeping your relational model in Excel.

Yeah, this is the way I would go too.