thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 956
- Office Version
- 365
- Platform
- Windows
hi all
before i dig in and research this, i thought i would ask here as you all have been extremely helpful in the past.
i have a proposal generating workbook. i enter in a bunch of “stuff” and my customer proposals are generated.
the proposals all require specific products be selected. these products are currently part of a table. the products are selected via validation lists and we use xlookuos throughout the workbook.
the problem i am having is that new products are always being added and so i add the product to the workbook i am working on and tgen for the next proposal, i open up the original workbook. i never have a true expanding database of products.
is there a way to create a separate workbook with just the products and have my proposal worksheet pull data from that workbook? that would allow me to update 1 file and would allow the list of products to expand.
any help or just general direction on what to research/learn would be greatly appreciated!!
before i dig in and research this, i thought i would ask here as you all have been extremely helpful in the past.
i have a proposal generating workbook. i enter in a bunch of “stuff” and my customer proposals are generated.
the proposals all require specific products be selected. these products are currently part of a table. the products are selected via validation lists and we use xlookuos throughout the workbook.
the problem i am having is that new products are always being added and so i add the product to the workbook i am working on and tgen for the next proposal, i open up the original workbook. i never have a true expanding database of products.
is there a way to create a separate workbook with just the products and have my proposal worksheet pull data from that workbook? that would allow me to update 1 file and would allow the list of products to expand.
any help or just general direction on what to research/learn would be greatly appreciated!!