macro to move selection to sheet 3 if...

[AlixNB]

Help please!

I have a load of records, each record on its own row, that now differ slightly and visually and formula wise it's become a nightmare.

to resolve it, what i want to do (in english sentences) is:

Sheet 1 - Select cell in column B of the record.
If corresponding cell in column J has "00:00" [a time] in it
move contents of cells B:J and L:N of that record row to Sheet 3
(clearing the contents on Sheet 1)

I want to be able to click a macro-assigned autoshape to initiate the "Move" once i have selected the first cell.

on sheet 3... once the info is moved over... can I have an automatic popup userform with a combo box to populate Cell K in Sheet 3 (different to sheet 1)
[I have the userform already, so i imagine it would be a line in the code to call.userform"Banding" (where the combobox options are 1-4)


can anyone help with the code please?