Hi,

need help urgently. I am relatively proficient in excel, in terms of basic formulas and layouts... but have been tasked to do something i hv never heard of.

I have one spread sheet that adds up ave prices and the result will be tabulated into a cell. On the daily basis, this result will change as new entries are made.

This is simple.

In short, the ave px value will keep changing with new inputs. This price will then be used for pricing in other worksheets, detached from this folder.

Qn is, is there a way for the changes or the new ave price to be reflected in all the other separate spreadsheets.
Ie after changing the px in one spread sheet, how can the changes be reflected in other workbooks totally detached form the original workbook.

This is giving me headaches. Professionals, please advise.

Your assistance is greatly appreciated.

Jose