lookforsmt
New Member
- Joined
- Jan 31, 2014
- Messages
- 3
I have a excel sheet1:
Where in cell A1 there is a number which can be -ve or +ve number
I have Fixed value in cell A10 which is text and B10 is number and
another Fixed value in cell A11 which is text and B11 is number
My question is through vba code i want to check the value in cell A1, if it is +ve, then place the value of A10 & B10 in cell B1 & C1 respectively and similiarly place the value of A11 & B11 in cell B2 & C2 resepectively and
vice versa when the value is -ve.
Where in cell A1 there is a number which can be -ve or +ve number
I have Fixed value in cell A10 which is text and B10 is number and
another Fixed value in cell A11 which is text and B11 is number
My question is through vba code i want to check the value in cell A1, if it is +ve, then place the value of A10 & B10 in cell B1 & C1 respectively and similiarly place the value of A11 & B11 in cell B2 & C2 resepectively and
vice versa when the value is -ve.