xXMCP1317Xx
New Member
- Joined
- Jun 16, 2011
- Messages
- 4
Want to set up macro that does this...
if A2 and A6 are the same then take the cells below and divide, so A7/A2 and have it go in specified cell.
The add onto above can it be a range so A2:R2 and A6:R6 and having it do the division formula above.
So A2 = A6 so divide B2= B6 so divide but C2 <> C6 but instead D2 = C6.
if A2 and A6 are the same then take the cells below and divide, so A7/A2 and have it go in specified cell.
The add onto above can it be a range so A2:R2 and A6:R6 and having it do the division formula above.
So A2 = A6 so divide B2= B6 so divide but C2 <> C6 but instead D2 = C6.
