Hi everyone,

Sorry for breaking a rule in my first post. Great start, eh? I am trying to make something of an inventory sheet that will be "idiot-proof" and optimized. I am using the exact same macro code as posted in the previous thread: http://www.excelforum.com/tips-and-t...-criteria.html . I am using the third version of tigeravatar's code (thanks!!!) and having two small issues.

1) If I was to have something entered in a column (the column we are using to sort the data into new sheets) lets say... F5. Run the macro and have it entered into a tab named F5, but then in the future change the sort criteria to F3. When i run the macro again, it will create a new sheet labelled F3, which is good, and move the data to the new sheet labelled F3, which is also good, but it will leave a duplicate entry in F5. Is there a way to make the row be automatically removed from F5 when the sort criteria moves the data to F3?

2) Also is there a way to pre-define what column i want to sort by? It'd be nice if it automatically selected column L instead of me having to select it every time I want to "refresh" the sheets by running the macro.


Thanks for any help that I hope comes my way...