Hi All,
I've got one of my guys doing some mass data entry for a project and part of the process is filling out a fairly large userform. Part of the data capture involves pasting 20 or so values from a non-excel table into a userform (and he's currently doing it line by line which is painful).
The data is in two columns, 10 or so rows long and all rows are relevant, is there anyway of setting up the userform to allow the data to be pasted 'as-is', automatically populating a series of text boxes to match the source formatting or via some other user-form based method?
Example data to paste to userform:
Bookmarks