J
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
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