Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to macros
What I'd like to do, if possible:
Say the field in column "A" equals "complete" Then cut entire line and paste it in the next available line of a new spreadsheet and delete the old line from the original sheet. This is a project management worksheet. I want to be able to totally remove an item from the "To Do" sheet and place it on the "Complete" sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to macros
One way is to use datafilterautofilterfilter on completecopy/paste to
newdeleteunfilter. Record a macro while doing. -- Don Guillett Microsoft MVP Excel SalesAid Software "RA" wrote in message ... What I'd like to do, if possible: Say the field in column "A" equals "complete" Then cut entire line and paste it in the next available line of a new spreadsheet and delete the old line from the original sheet. This is a project management worksheet. I want to be able to totally remove an item from the "To Do" sheet and place it on the "Complete" sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |