Would something like this work?
FirstRow = 5
LastRow = 15
SourceColumn = 2
DestColumn = 9
For CurrentRow = FirstRow To LastRow
Cells(CurrentRow, SourceColumn).Copy
Cells(CurrentRow, DestColumn).PasteSpecial xlPasteValues,
xlPasteSpecialOperationNone
Next 'CurrentRow
HTH
Chris
"Belle" wrote in message
...
I have a spreadsheet with data pulled from my database. I want to take
the value in the last cell of each row and move it into a new cell, one
that I specify.
In other words, for each row, take the data in the last column and move
it to column X, same row. The column to move to will be the same for the
entire sheet.
--
Belle
------------------------------------------------------------------------
Belle's Profile:
http://www.excelforum.com/member.php...o&userid=15736
View this thread: http://www.excelforum.com/showthread...hreadid=272517