OK so I have this piece of code that will, when a command button is pushed trawl thru my sheet and copy and paste all completed actions to another sheet. But...it'll only work when the button is pushed and when the button is pushed some days later the same info is copied and pasted along with new info.
So can someone add to my bit of code another bit of code that will clear the 'Completed cases' page prior to pasting the new data and a piece of code that will do all this when a new completed case is inputted in into 'Cases by case number' page please.
Thanks in advance
As below
Bookmarks