joeyc
09-19-2008, 10:01 PM
Hi,
Let me start off by saying I think I dug a hole for myself and am trying to fix this thing. I am good with formulas and not with writing custom code.
I have a workbook that I attached as a sample. The purpose of this workbook is to streamline the data entry process. A user would complete the set of questions on the Fee Input page (and there are A LOT of them, no doubt!) and these answer will get transferred over to the other pages. Simple enough?
The problem is this workbook can only hold 1 product. This is THE problem! Now we deal with high volume. One client may have 20 products. So that means I need 20 workbooks. Needless to say, this is cumbersome.
My question is, at this point what can I do so that this workbook can house many products? Is their a solution you can see that I am overlooking?
Please let me know if I am not explaining anything clearly. Thank you in advance for any assistance.
:help
Let me start off by saying I think I dug a hole for myself and am trying to fix this thing. I am good with formulas and not with writing custom code.
I have a workbook that I attached as a sample. The purpose of this workbook is to streamline the data entry process. A user would complete the set of questions on the Fee Input page (and there are A LOT of them, no doubt!) and these answer will get transferred over to the other pages. Simple enough?
The problem is this workbook can only hold 1 product. This is THE problem! Now we deal with high volume. One client may have 20 products. So that means I need 20 workbooks. Needless to say, this is cumbersome.
My question is, at this point what can I do so that this workbook can house many products? Is their a solution you can see that I am overlooking?
Please let me know if I am not explaining anything clearly. Thank you in advance for any assistance.
:help