Forum Discussion
DBlackwood
Mar 02, 2023Copper Contributor
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?
- peiyezhuBronze Contributor