maintaining a link between spreadsheets?

[Rameses]

G'day

The following is all in the same workbook (5worksheets)

Worksheet 1 'Overview' is made from appending information from all the other 4 user worksheets 'user1, user 2, user 3, user4'

Whilst I have been able to append the data using VBA, I need to maintain a link between the spreadsheets so that any change in for example 'user 2' would be reflected in 'overview'

anyone know how i can do this?

Rameses

 

[dave3009]

Sounds like it can be done but without more information it's going to be hard. Can you post up some screenshots please.

Ta

 

[sykes]

Seems a bit obvious, but can't you just put formulae in the ranges in "Overview" which then reflect any data in the sheets in question.......?
=User2!A1

 

[Domski]

The best approach is to have a single data source on one sheet, if that isn't possible I would suggest just refreshing the entire overview sheet as and when required by pulling all the data from the other 4 sheets in their entirety rather than trying to capture any changes that are made and reflecting them in the master data.

Dom

 

[Rameses]

Hi Domski /Dave 3009

I have had to do it that way but

lets say in my overview (sheet 1) I have data from A1:A25

In A30 I have a formula based on the data A1:A25

I have linked A10:A15 across to Sheet 2 and I also want the same formula across to sheet 2 but this time to calculate for the values A10:A15 is there a way to carry this over but for it to focus on the data held within its sheet ie.A10:A15

unfortunately cant provide a screenshot Dave 3009 as using parallels in mac

many thanks
Rameses