Alternative to External Worksheet Reference

[thewiseguy]

Hi all,

I have a list of products we sell, that is constantly changing. Product names, numbers etc are changing all of the time. We add products and remove products as well.

Currently I have a master worksheet where I input data and then a proposal is created for my customers.

I have decided, the best way to do this going forward is to have 1 workbook, strictly to hold all of my product data (numbers, pricing etc) and then have another proposal document to create the proposal to send to my customers.

Before I go and research the best way to do this, I am curious if there are any other ways to do it other than creating an external worksheet reference?

Any help or direction is greatly appreciated!

 

[Larry Haydn]

You can have a master file to save all the products - all updates and new products goes here.
Then you can rig your Excel application copy this this master list to your work file every time you open your work file.
You can then reference the list within your work file.