Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to move data to a specific cell?
I have a spreadsheet with data pulled from my database. I want to tak the value in the last cell of each row and move it into a new cell, on that I specify. In other words, for each row, take the data in the last column and mov it to column X, same row. The column to move to will be the same for th entire sheet -- Bell ----------------------------------------------------------------------- Belle's Profile: http://www.excelforum.com/member.php...fo&userid=1573 View this thread: http://www.excelforum.com/showthread.php?threadid=27251 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to move data to a specific cell?
Hi
AFAIK they are stored in Excel's *.xlb files -- Regards Frank Kabel Frankfurt, Germany "Belle" schrieb im Newsbeitrag ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to move data to a specific cell?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to move data to a specific cell?
I believe you could copy the entire row and move it to row x. I have a book at work that shows how to do this... but I hope the idea helps. its something to the effect of: activecell.range("F").copy activecell.range("X").paste (mybe you could even cut, or else after you copy, just delete the entire column?) Does anyone think this method would work for Belle -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=272517 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cursor to specific cell from a specific cell | Excel Discussion (Misc queries) | |||
Macro to Move Specific Data to Another Worksheet | Excel Worksheet Functions | |||
Move Specific Data to Another Worksheet | Excel Worksheet Functions | |||
How do I move to a specific cell in Excel? | Excel Discussion (Misc queries) | |||
Move to a specific cell | Excel Programming |