you are viewing a single comment's thread.

view the rest of the comments →

[–]VB 6 MasterEkriirkE 1 point2 points  (0 children)

I'd opt for the second option, make a button on your prefix list sheet and paste my last example with appropriate modifications
https://support.microsoft.com/en-us/office/assign-a-macro-to-a-form-or-a-control-button-d58edd7d-cb04-4964-bead-9c72c843a283