Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to move row from worksheet to another
Within the same workbook I need to move an entire row from one worksheet to
another worksheet. It only needs to happen daily after i've updated the status of certain rows to "Uploaded" in colum L. The problem i am having is with the copy and paste and, as always, with the loop. I'm just not good with loops. I appreciate any suggestions i get. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to move row from worksheet to another
Hi KWhamill
Start here http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "KWhamill" wrote in message ... Within the same workbook I need to move an entire row from one worksheet to another worksheet. It only needs to happen daily after i've updated the status of certain rows to "Uploaded" in colum L. The problem i am having is with the copy and paste and, as always, with the loop. I'm just not good with loops. I appreciate any suggestions i get. __________ Information from ESET Smart Security, version of virus signature database 3952 (20090320) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3952 (20090320) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to move row from worksheet to another
Perhaps I should be more specific. I need a Macro that will cut the row when
the value in column L Says "uploaded". Then paste that onto the next work sheet. Finally take out all the blank spaces. I can find The entries that say Uploaded, however I can not figure out how to tell the computer to select the row after that. Copy and Paste I'm OK with I think i can handle the Append part even. I know i have the delete blank rows taken care of. and the other problem i have is with the loop, I'm not good writing loops "KWhamill" wrote: Within the same workbook I need to move an entire row from one worksheet to another worksheet. It only needs to happen daily after i've updated the status of certain rows to "Uploaded" in colum L. The problem i am having is with the copy and paste and, as always, with the loop. I'm just not good with loops. I appreciate any suggestions i get. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move to a named worksheet from any worksheet in the same workbook | Excel Programming | |||
Move row to another worksheet | Excel Discussion (Misc queries) | |||
How to move from one Worksheet to another. | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
How do I use vb to move from worksheet to worksheet in a workbook. | Excel Programming |