david7281
02-12-2013, 03:27 AM
I need help for VBA.
I have a club and i have just made a button called archive and when it is clicked a takes cells a2,a3,a4 which is being lookuped from the members table and it copys it in to the archive table.
But what I need is that once a member has been put into the archivve table I want it to delete from the members table how do i do it in vba code many thanks
I have a club and i have just made a button called archive and when it is clicked a takes cells a2,a3,a4 which is being lookuped from the members table and it copys it in to the archive table.
But what I need is that once a member has been put into the archivve table I want it to delete from the members table how do i do it in vba code many thanks