thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
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!
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!