Hi,

Hoping someone can assist.

I have a table with data and a form in sheet 2 with numerous text boxes.

What I need is data in Column E (startung at E6) to be copied to Texbox 1 in sheet 2.

Also for data in Column B (starting B6) to be copied to Textbox 27.

The next step is for all the textboxes and data in sheet 2 to be generated into an email, when a button is selected.