Multiple Criteria Met on Worksheet "A" Pulls Info from Hidden Worksheet "B" Cell
Two (2) worksheets - A and B
Three Columns on Worksheet A: A1 = "Description" (static list); B1 = "Product" (drop down list); C1 = "%" (drop down list)
If "Egg" is chosen from B1 drop down list and "5%" is chosen from C1 drop down list, each cell of the column below B1 will pull particular cell data from a separate worksheet. The cells of the second worksheet have been formulated for the correct percentage above net value ($1, $2,... )
Worksheet should be protected when complete, so the viewer does not see the formulas or any of the second worksheet. It would be best if the "%" did not show on the first worksheet and would print as a PDF, not a workable template for the customer to manipulate.
Original Worksheet A:
In Progress Worksheet A:
Final Look Worksheet A:
VBA is not my strong suit, but if that is the best way to get what is needed, I'm up for learning. If not here, please direct me to where I should go.
Thank you for your attention to this query.
Two (2) worksheets - A and B
Three Columns on Worksheet A: A1 = "Description" (static list); B1 = "Product" (drop down list); C1 = "%" (drop down list)
If "Egg" is chosen from B1 drop down list and "5%" is chosen from C1 drop down list, each cell of the column below B1 will pull particular cell data from a separate worksheet. The cells of the second worksheet have been formulated for the correct percentage above net value ($1, $2,... )
Worksheet should be protected when complete, so the viewer does not see the formulas or any of the second worksheet. It would be best if the "%" did not show on the first worksheet and would print as a PDF, not a workable template for the customer to manipulate.
Original Worksheet A:
| Description | Product | % |
| 1 Pound | ||
| 2 Pound | ||
| 3 Pound |
In Progress Worksheet A:
| Description | Egg | 5 |
| 1 Pound | ||
| 2 Pound | ||
| 3 Pound |
Final Look Worksheet A:
| Description | Egg | |
| 1 Pound | $1.05 | |
| 2 Pound | $2.11 | |
| 3 Pound | $3.16 | |
| 4 Pound | $4.21 | |
| 5 Pound | $5.26 | |
| 6 Pound | $6.32 | |
| 7 Pound | $7.37 |
VBA is not my strong suit, but if that is the best way to get what is needed, I'm up for learning. If not here, please direct me to where I should go.
Thank you for your attention to this query.