Forum Discussion

DBlackwood's avatar
DBlackwood
Copper Contributor
Mar 02, 2023

Exporting excel data to web form

Every month my company transfers costs from one account to another for hundreds of line items. We use the data from excel to populate a webform. I'm sure there is a way to automate this process with VBA but I'm not sure where how to proceed. The two pictures attached show the webform that will be filled and the excel sheet that contains the lines. There can be 1,000 lines that all have to be input one line at a time.

Does anyone have suggestions for the best function to incorporate to past the data from the cells into the respective form field based on part of the field's code? 

Resources