Adds abd Deletes

P

Peter Gedney

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?
 
F

Franz Verga

Peter Gedney said:
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?
Click to expand...

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
 
Top