Previous Topic Next Topic

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

Closed
Bazzip Posts 1 Registration date Monday December 7, 2009 Status Member Last seen December 8, 2009 - Dec 8, 2009 at 06:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 8, 2009 at 06:53 AM
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
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 8, 2009 at 06:53 AM
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
0