This will prolly go unanswered but..I have worksheets emp1 thru emp24. I
would like to place a command button on each sheet that when clicked will
allow me to move the sheet to another excel file that had tne same name but
is in a different folder. In addition I'd like the worksheet to take the
place of one of the worksheets in the new file as long as the worksheet does
not have a value in cell B4. So if file 1 emp5 is moved to file 2 it looks
for the first sheet with an empty B4 in file 2 and replaces it with the
worksheet from file1. So in theory file1 emp5 could become file2 emp8.I'd
also like file1 emp5 to retain its name but be clear of information in
unlocked cells (if it matters the worksheets are protected). Each employee
has his own worksheet but may switch teams at any time. Each team has it's
own file. I know I'm prolly asking for way too much here.