Addidng data automatically after Conditions are met

[kshora]

Can I add data in a cell automatically, after the conditions are met in two different cells

e.g A1 has 3600
A2 has 0.33
When I enter the above data in A1 and A3, I want to get say "184T" in Cell A3. OR if I enter 1800 in A1, data in A3 should be say "145T".
There are lot more combinations to work with.

Your help is highly appreciated

Thanks and Regards

KShora

 

[onlyadrafter]

Hello,

THis code needs to go into the relevant sheet code window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Or Target.Address = "$A$2" Then
    Select Case Range("a1") & Range("A2")
        Case 36000.33
            Range("a3").Value = "184T"
    End Select
End If
End Sub

you will need to add all other combinations yourself by adding and changing these lines

        Case 36000.33
            Range("a3").Value = "184T"

 

[kshora]

Hi

When I put the code in the code window (pressing ALT+F11), and change the data and cells as required, and after I close the window and go to tools>macro>macros; this macro does not appear and hence cannot run.

Am I doing any mistake

Regards

KShora

 

[kshora]

Hi

I think I figured it out, and am sure that I could not explain the problem correctly. Let me try to explain my problem again

eg. the following is a data sheet, with values, now this data is already there, what I want is that I want certain data in column D after the conditions in column A and column B are met. say D1 should be 56T, D2 should be 56H, D3 should be 184TS and so on.

A B C D E
1 900 1/3 00 - 21 56
2 900 1/2 22 - 29 56
3 900 3/4 30 - 40 184
4
5 1200 1/2 00 - 16 56
6 1200 3/4 17 - 22 56
7 1200 1 23 - 27 145
8 1200 1 1/2 28 - 35 182
9 1200 2 36 - 40 184

Your help is highly appreciated

Thanks and Regards

KShora

 

[kshora]

The worksheet got messed up
A, B, C, D AND E are the columns and 1 to 9 are the rows, the values are
A1=900, B1=1/3, C1=00 - 21, D1 is blank, E1=56 and so the rest of the work sheet, I hope the above is clear

Please help me out.

Thanks and regards

KShora

 

[kshora]

Any one, please help me out

Thanks and Regards

KShora

 

[xcellnoob]

how many different conditions are there? Basically, how many different D-cell values are there?

 

[kshora]

Hi
Thanks for your reply

There are 9 different values in D-cell

4 different values in A-cell
21 different values in B-cell

Thanks and regards

Kshora

 

[xcellnoob]

you could set up a table with all the different combinations and use vlookup to grab the resulting value. you can email me your file if you'd like and I can take a quick peek.
one2345@eml.cc

 

[kshora]

I sent you the email, with a portion of the worksheet

Regards

KShora