I have a large spread sheet where some values down load to the wrong column. To fix this I am looking for a macro that can look in Column H and where it finds Balance Forward look in the same row at column J and if there is a value move that to column K.
Columns L and M will have values in them that need to stay.
Example: H15 = Balance Forward, J15 = 214,111.63, K15 blank cell, L15 2,300.70 (needs to stay), M15 = 2,389,858.62 (needs to stay).
Thank you
Mark
Columns L and M will have values in them that need to stay.
Example: H15 = Balance Forward, J15 = 214,111.63, K15 blank cell, L15 2,300.70 (needs to stay), M15 = 2,389,858.62 (needs to stay).
Thank you
Mark