gdiamonds22
New Member
- Joined
- Dec 6, 2005
- Messages
- 4
I'm new to VBA and I need assitance in writing a macro that automatically puts a value in a cell in respect to what a cell in a different column is. For example.
Column A Column B
parent
child
aunt
*My macro needs to say if column A is "parent" then column B should be "1", if column A is "child" column B should be "2"...etc
Thanks in advance for any help.
Column A Column B
parent
child
aunt
*My macro needs to say if column A is "parent" then column B should be "1", if column A is "child" column B should be "2"...etc
Thanks in advance for any help.