Hello everyone
I am hoping someone may be able to assist me. I have an Excel 2007 spreadsheet with two tabs; Master (sheet 1) and Closed (sheet 2). Currently there is scripting that will move an entire row from the Master sheet to the Closed sheet if the word "closed" is in column G. The Master tab auto sorts alphabetically once a new name is added and the sheet is activated however I cannot get the Closed tab to auto sort as well. I tried pasting the same coding in the window for Sheet 2 (closed tab) but that did not work. Does anyone know what I am doing wrong?
I have attached a copy of the spreadsheet.
Thanks for looking at this.
Bookmarks