Copying last cell's datal in one column to first cell in next column?

[jonco]

I have several columns of data. For instance:
Col B Col C Col D Col E Col F Col G
Row 1 250 125 89
Row 2 125 217 144
Row 3 166 144 105
Row 4 122 110
Row 5 155
Row 6

What I need is to be able to copy the last item in Col B (166 in Row 3) into
C1 and the last item from Column D (155 in Row 5) into E1 etc. I have three
colums I need to do this to. The number of the filled cells in the colums
could be anywhere from 1 to 6. Any suggestions on how to do this would be
appreciated.

Jonco

 

[Earl Kiosterud]

Jonco,

Select the cell in B3, and edge-drag it, holding Shift, above C1. This will
move the stuff in C down. If you don't want that, don't use Shift.

 

[Jonco]

What I meant was to do this automatically using a formula or VBA if
necessasy. I know how to copy & paste. Thanks anyway Earl.

Jonco

 

[Gord Dibben]

Jonco

If always numeric data in B, D, F

In C1 enter =LOOKUP(9.99999999999999E+307,B:B)

In E1 enter =LOOKUP(9.99999999999999E+307,D)

If not numeric use =LOOKUP(REPT("z",255),B:B)


Gord Dibben Excel MVP

 

[Duke Carey]

Gord -

Would you be kind enough to explain how in the heck that works. I'm not
smart enough to understand what it's doing.

Thanks
Duke

 

[JulieD]

Hi Duke

check out
http://www.xldynamic.com/source/xld.LastValue.html

for the first two formulas read sections -

#002 - Searching For Largest Possible Number Using LOOKUP
(and you'll probably have to read #001 as well)

for the last formula check out
#006 - Searching For Largest Possible Number Using LOOKUP
(and have a read of #005 as well)

Cheers
JulieD

 

[Gord Dibben]

Thanks Julie

Hope this helps you Duke.

I can't say it any better(or even near as well)than Frank and Bob have done.


Gord

 

[jonco]

Thanks for the help guys (and gals). I will check it out. I appreciate the
help.
Jonco