Currently I have a worksheet with 30 rows that I paste a series of text data into (Col D) from another source. I then have a button with VBA macro that when executed separates out the text (Col D) into columns F through J. The macro works perfectly.

What I was wondering, if I created a new workbook is it possible to have a button that when executed will: (1) open a form that has say an area to paste 30 rows of text into, (2) separates the text strings into a column format and, (3) finds the last row in a worksheet and fills in the worksheet with the extracted data.

Thanks for your thoughts and direction.