Hello forum:

I need HELP! I have a formula based solution to a program management document for my job at work but I have recently discovered some bugs with using this formula solution. It causes some problems for managing the data. I have attached an example of the basics of what I try to do with the formula and what is happening with it currently. If you could take a look and see if you can see a macro solution that will solve my issue or any other suggestions are welcome!

I basically want to move data from Sheet 1 to sheet 2 after certain criteria are met and the move is based on individuals names. Thanks for the help.

HELP ME.xlsx