I have a spread sheet that has a list of employees and transactions that they have done through out a given month.
Example:
Employee No., Effective Date, Amount1, Amount2
0001, 2/1/2009, 50, 100
0002, 2/1/2009, 50, 0
0003, 3/1/2009, 0, 0
I need a way to make it so that the "Amount1" and "Amount2" be seperated into there own line item, except when the cell is equal to either 0 or is blank.
Desired Solution:
Employee No., Effective Date, Amount1, Amount2
0001, 2/1/2009, 50
0001, 2/1/2009, , 100
0002, 2/1/2009, 50
This is a much simplified version of what I am actually looking to do. I usually create Macros and then edit my VBA code from there, but this is a little beyond me. This is a procedure that will need to be done often, so if anyone has any tips or any helpful ideas it would be greatly appreciated and would save me a TON of time.
Thanks in advance!!
Example:
Employee No., Effective Date, Amount1, Amount2
0001, 2/1/2009, 50, 100
0002, 2/1/2009, 50, 0
0003, 3/1/2009, 0, 0
I need a way to make it so that the "Amount1" and "Amount2" be seperated into there own line item, except when the cell is equal to either 0 or is blank.
Desired Solution:
Employee No., Effective Date, Amount1, Amount2
0001, 2/1/2009, 50
0001, 2/1/2009, , 100
0002, 2/1/2009, 50
This is a much simplified version of what I am actually looking to do. I usually create Macros and then edit my VBA code from there, but this is a little beyond me. This is a procedure that will need to be done often, so if anyone has any tips or any helpful ideas it would be greatly appreciated and would save me a TON of time.
Thanks in advance!!