I wished I could do this in Access, but I'm the only one in the dept
who has it. And, what I'm designing will be used by others. So, I have
to try to do this within Excel.

The user will flip through a report at the end of the day. He will
enter PO numbers on a UserForm that will cause the line with that PO#
to be moved to another sheet. I think I can get this part done (albeit
with crude coding). While flipping through the report, the user might
also need to edit existing lines. In my dreamworld, I would like to
have a different TextBox in that UserForm where the user can enter a
PO#, then click a button next to it that will let the user edit any of
the cells in that line the PO is in.

When that button to edit is clicked, I would like for any of the
TextBoxes already filled in on the original UserForm to be applied to
their appropriate destinations. Then another UserForm comes up, with
all the fields populated with the data on that PO line just requested.
Something tells me this is either not doable, or else will require some
rapid expansion of knowledge on my part.

Once the editing is completed, the 1st UserForm comes back for more
entries of lines to move, or edit. Again, the easy part.

Before I decide how much time I will spend on this part of my overall
project right now, I would like anyone to please let me know 1st of all
if any of my hopeful assumptions above are out of the question. Can I
have a UserForm come up where the fields will be populated with a
current record based on the user's selection?

If not, maybe you can give me an idea of key terminology I need to
understand before trying to get this done in another way. Just trying
to get a feel for how much time I will need to devote to this.

It may be alot of info I'm asking for. But, if anyone cares to chime
in, I would appreciate it.
Thanks
J.O.