Copy from Excel into webform fields

fajpao

New Member
Joined
Apr 1, 2020
Messages
1
Office Version
  1. 2010
Hello,
I'm new to this, and read through multiple threads but all I found talk about automation.

I don't need to automate (at least not yet) but I have a spreadsheet of data (one column, 2,000 rows) that I need to be able to copy and paste into a web form that is just multiple boxes. The webform only allows 20 entries at a time, so if I copy 20 rows from Excel and paste, they all go into the first box of the webform.

How can I paste so that each cell's data from Excel pastes into a different box on the webform? Is this only possible through vba and automating the process?

I don't have admin rights to my computer so I can't download anything.

Thank you if you have any tips to share.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
These automations require a tight integration with the html source code of the web page, so if you can share the url.

Bye
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top