Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks

There's actually a few ways to achieve this. So the easiest, assuming that
each row will only have a value in either column B or C, then simply use a
sum function in column D. If some rows have values in both column B and C,
then you may need to use an if statement in column D.

"Soth" wrote:

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks

Nuzza, yes some rows have values in both column B and C, and how do I write
if statement?

Thanks

"Nuzza" wrote:

There's actually a few ways to achieve this. So the easiest, assuming that
each row will only have a value in either column B or C, then simply use a
sum function in column D. If some rows have values in both column B and C,
then you may need to use an if statement in column D.

"Soth" wrote:

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks

Select column B

F5SpecialBlanksOK

EditDeleteShift cells left.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 16:10:01 -0700, Soth
wrote:

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks

Hi,

Select column B and press Ctrl+G Special Blanks OK. This will select
all the blank cells. Now press the right arrow key and press Ctrl+Enter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Soth" wrote in message
...
Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive
this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks