Using VBA to get value from 3 variables......

Closed
Report
Posts
1
Registration date
Monday December 7, 2009
Status
Member
Last seen
December 8, 2009
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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......

Bazzip

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
in the first row where the names product 1,product 2 etc are written.
are the cells merged while writing these entries.
preferably do not merge cell if you want to use vba

if possible send a small extract of your sheet by email to me . remove dollar signs from the email address below

$$$venkat1926$$$@gmail$$$.$$$com