Hello, I have a table of data layed out as follows: B1 = Product 1, E1 = Product 2, H1 = Product 3, K1 = Product 4 and so on
Row 2 all Products split again in B2 = Rep A, C2 = Rep B and D2 = Rep C and repeat...
Column A, A3=100, A4=98, A5=95, A6=92 and a few more
Product 1,2 or 3 and so on is manual input and shown in Cell "A10" as so is Rep type a,b or c manual and shown in Cell "A11". % 100,98,95 or 92 and so on is calculated and shown in Cell "A12".
The table is then filled with single digit figures one of which I want to retrieve.
How can I us VBA to pull corresponding value out of the table? By Product 2, Rep Type and calculated %?
My VB is Very Basic...but I can prepare a easy to medium difficulty code.
Have modified the original message as the table comes out all over the place when I tried to display it a s table, please forgive me if it is a little difficult to understand......