If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
move rows to another worksheet
On a stock control sheet once an item has been logged out (by date) I would
like the entire row automatically moved to another worksheet. This would then collate all items logged out on a history worksheet and leave a current available list on the original worksheet. Thanks for any help on this. |
#2
|
|||
|
|||
move rows to another worksheet
You can use cut/insert or copy/paste/delete original. Record a macro. Clean
it upassign to a button or automatic worksheet_change event. If all else fails. If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "buffysmum" wrote in message ... On a stock control sheet once an item has been logged out (by date) I would like the entire row automatically moved to another worksheet. This would then collate all items logged out on a history worksheet and leave a current available list on the original worksheet. Thanks for any help on this. |
Thread Tools | |
Display Modes | |
|
|