Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a range to end of list
Thanks Don, Can we go a little further with this? I see moving the data i fairly easy. Now, how can I move the data to the end of the list afte every new entry? This list is growing and I won't be putting th information in the same cell. Also, I would like to move this dat without the current cell formatting. Thanks Again :) Sinjin34 -- Sinjin34 ----------------------------------------------------------------------- Sinjin341's Profile: http://www.excelforum.com/member.php...fo&userid=1461 View this thread: http://www.excelforum.com/showthread.php?threadid=26244 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a range to end of list
try this
Sub moverange() x=cells(rows.count,"H").end(xlup).row+1 range(cells(x,"h"),cells(x+3,"I")).value=Range("f1 2:g15").value Range("f12:g15").entirerow.delete End Sub -- Don Guillett SalesAid Software "Sinjin341" wrote in message ... Thanks Don, Can we go a little further with this? I see moving the data is fairly easy. Now, how can I move the data to the end of the list after every new entry? This list is growing and I won't be putting the information in the same cell. Also, I would like to move this data without the current cell formatting. Thanks Again :) Sinjin341 -- Sinjin341 ------------------------------------------------------------------------ Sinjin341's Profile: http://www.excelforum.com/member.php...o&userid=14616 View this thread: http://www.excelforum.com/showthread...hreadid=262444 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving range? | Excel Discussion (Misc queries) | |||
sum with moving range | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Moving a range to end of list | Excel Programming |