Linking Spreadsheets in Excel 2007

[sdc1234]

I have 4 little daily report and 1 master report; I am trying to link them together so that when someone enters a total on the little report it will change the master report, any advice…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
thx

 

[B4L4KS]

hi

if i understand you correctly you have reports that have data on them and when you change a cell in one of the smaller reports the larger report will change with the data,

is that right and if so please upload the cells that you require

kristian

 

[sdc1234]

I am not able to upload because I am new but I will explain in detail, I have a daily total on 1 report in (report1-a3) I when I change the number in (report1-a3) I need the # to change in (report5 B4)and so on...

any help would be appreciated

thx

 

[B4L4KS]

hi

if you have a cell that is your daily total, the use a simple formula of =cell, so use the equals sign to the cell you want and go from there

note: if you have a merged cell such as A12:A13 delete the last number of :A13 so it can recognize the cell,

if i had the sheets with data i could help further

kristian

 

[sdc1234]

so what u r saying is that in report 5 B5 (the master report), I would just do an =cellreport1b3, or am I totally off-base...

thx

 

[B4L4KS]

yes

sort of, your question is confusing without DATA!

are you using text or numbers in the cells

 

[sdc1234]

all #'s

 

[B4L4KS]

hi

sorry for being thick as well but what is #

 

[sdc1234]

numbers

 

[B4L4KS]

ok sorry

then if you trying to create a total on the other pages then use the =sum() function or =Product()

for text just use =cell

kristian