Separate value in 1 column to 2 columns based on value in othe
Hi Kassie, thanks for the response i can see how it could read confusingly so
i added a follow up reply which shows an example of the information that i'm
working with and what I'd like it to appear as:
$400.00 DR
$550.00 DR
$59.00 CR
$88.00 DR
$757.00 CR
I'd like to macro to move the credits over like this:
$400.00 DR
$550.00 DR
$59.00 CR
$88.00 DR
$757.00 CR
I hope that makes it easier to get my request across. the columns that i'm
working with are B, C and D but for some reason they are showing up as
numbers like the rows do and not letters, that's where i think i got confused
when trying to explain the question in the original first post.
"Kassie" wrote:
Not at al clear what you want to do here!
have the values in C2 move (cut/paste) to Column 3 - But column C is column 3?
if the value in C4 is a CR.
Why move C2 if C4 is a credit?
I would understand if you stated htat you have a column, say C, which
contains both credits and debits, and you want to move the debits to say col
D and the credits to say Col E. The only wuestion would then be how are you
differentiating. The logical answer would be the credits are preceded by a
-. Now that's easy. Is this what you want, else be a bit more specific?
--
HTH
Kassie
Replace xxx with hotmail
"Versace77" wrote:
Hi everyone,
Looking for help on trying to separate debits/credits that are listed in one
column (Column 2). Column 4 has either a DB or CR. I'm looking for a way to
have the values in C2 move (cut/paste) to Column 3, same row, if the value in
C4 is a CR.
Thanks as always.
Versace77
|