Hi All,
I am working on a user form using a ListBox called ListBox1 and TextBox called TextBox10 and a command button called cmdArchove
ListBox1 contains 11 columns of data which is sourced from sheet1 A2:K
The idea is to use TextBox10 to search ListBox1, then use multiselect to chose employee items to archive in sheet4 and deleting from source sheet1.
the data in column 11 is a unique reference number for the row of data.
Can anyone help with a code to enable this to happen?
Many thanks in advance.
Andy