In the following thread a week ago, I asked for and received some VBA help, but I have encountered a problem with it.
http://www.mrexcel.com/board/viewtopic.php?topic=1117&forum=2
The problem is this: when an employee enters an S in Col. K, the data moves from one worksheet to the next perfectly, but, when the rows move up, the information from the row above the deleted row copies its information to the row below the now deleted row. For example, if the unit in row 11 is sold, when the S is entered in column K, row 11 cuts and pastes itself to the next worksheet, and row 12 becomes row 11. It copies the data from row 10 and overwrites the true data.
I have been reading the boards for 3 days trying to work this out and am throwing in the towel. Please help!
Thank you
http://www.mrexcel.com/board/viewtopic.php?topic=1117&forum=2
The problem is this: when an employee enters an S in Col. K, the data moves from one worksheet to the next perfectly, but, when the rows move up, the information from the row above the deleted row copies its information to the row below the now deleted row. For example, if the unit in row 11 is sold, when the S is entered in column K, row 11 cuts and pastes itself to the next worksheet, and row 12 becomes row 11. It copies the data from row 10 and overwrites the true data.
I have been reading the boards for 3 days trying to work this out and am throwing in the towel. Please help!
Thank you