Prev: MSN MoneyCentral stock quote
Next: If statement in excel
From: buffysmum on 1 Jun 2010 07:50
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.
From: Don Guillett on 1 Jun 2010 08:16
You can use cut/insert or copy/paste/delete original. Record a macro. Clean
it up>assign 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
dguillett(a)gmail.com
"buffysmum" <buffysmum(a)discussions.microsoft.com> wrote in message
news:6FED6036-0AB8-40DB-9347-DA30733199D7(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: MSN MoneyCentral stock quote
Next: If statement in excel