Use InputBox Value to Copy Cells From One Row to Another Row

[edneal2]

I have a sheet that includes names and numbers in two separate sections of rows. I have found a macro that helps me move explicit row values from one section to the other, by specifying in the code which cells I would like to move. What I would actually like the code to do (and I have started the code for this) is use an input box value to find a specific name in one section, and move both the name, and the 3 numeric values in the next 3 columns up or down in to the other section of names. Ideally, I would be able to search for a name in the lower section through an input box, move that name and its 3 numbers into the next available row of cells in the section above it, and vice versa.

Here is the code I have so far:

Please Login or Register  to view this content.

And I have attached a dummy sheet that i am practicing the code on. Any help on getting this to work would be greatly appreciated.