Grace79
03-06-2006, 09:41 AM
Hello
I am new to this forum and to VBA. :help
I'm not sure if what I'm after can be done - I've got one worksheet (called "open") where each row is an idea. One of the columns shows the status of the idea, either open or closed.
Is it possible that when the status is closed, the row can be cut and pasted to an existing worksheet ie named "closed"? And also can the row be deleted so not to leave a gap on the "open" sheet?
Any help would be much appreciated.
Thanks
Grace
I am new to this forum and to VBA. :help
I'm not sure if what I'm after can be done - I've got one worksheet (called "open") where each row is an idea. One of the columns shows the status of the idea, either open or closed.
Is it possible that when the status is closed, the row can be cut and pasted to an existing worksheet ie named "closed"? And also can the row be deleted so not to leave a gap on the "open" sheet?
Any help would be much appreciated.
Thanks
Grace