When changing a previously selected drop down choice, it does not insert the new data correctly on another worksheet

[katiedee]

I was going to attach a workbook, but it won't let me. I guess it's because I'm new to the forum. I'll describe the best I can the problem in hopes that I can attach my very scaled down workbook at some point. The workbook is designed so that any row on the Company One or Company Two tabs that contain "Unsuccessful" in column J will copy cells on the same row from the B, D & E column over to the Unsuccessful worksheet. On that sheet the columns D, E, F, G & H are then completed manually. Column E & F have drop downs. All of this works great, EXCEPT if you go to either the Company One or Company Two worksheet and change any "Successful" in column J to "Unsuccessful." It will still copy the data to the Unsuccessful worksheet, however, wherever the new data is inserted does not insert a whole row.

The best way I can explain it is if you go tothe Company One tab and change J5 to Unsuccessful and then look at theUnsuccessful worksheet, you will see where it inserted the change to row 4, columns A, B & C.However, D4-H4 remains the same, which was information associated with the client that is now A5-C5.

I should also mention that the Shared Data worksheet is for storing the data from Company One and Company Two. The Unsuccessful worksheet has formulas for each row to pull the data from the Shared Data tab if it meets the criteria.

I just don't know how to get the data from Company One or Two to the Unsuccessful sheet on the next blank row. I know it's doing what it's doing because of the formula I have for each specific row of columns A, B & C. I'm sure there's a better way.

Appreciate any help!

 

[mumps]

You can't attach files in this forum. To attach a file, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. You can attach screen shots. Click this link and look at Section B for instructions: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[katiedee]

I have received an outside solution, but thanks to those who've taken the time to read my question.