I maintain an inventory (products list) in Excel. I use the data in this
sheet in a few other Excel documents. I'm able to link individual cells in
my other reports to the products list which is helpful in keeping my prices
current in all of my sheets and, most importantly, this process is automatic
and an enormous time saver. Is there a way to update my other reports when
I make additions or deletions to the products list?

"Peter Gedney" <(E-Mail Removed)> ha scritto nel messaggio
news:e8dzg.317$L31.114@trndny06...
>I maintain an inventory (products list) in Excel. I use the data in this
> sheet in a few other Excel documents. I'm able to link individual cells
> in
> my other reports to the products list which is helpful in keeping my
> prices
> current in all of my sheets and, most importantly, this process is
> automatic
> and an enormous time saver. Is there a way to update my other reports
> when
> I make additions or deletions to the products list?
>
>

Hi Peter,

You could use a dynamic named range in your source file (products list) and
then reference this name from the other files.

You can see how to create a dynamic named range here (pages from Chip
Pearson's site):

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

http://www.cpearson.com/excel/named.htm#Dynamic


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy