ix bug or create new program.
Below is a project I create a while back. It worked for a few weeks until one of my staff used a symbol in a form field and the program has a bug. The Freelancer has not responded for requests to help fix the bug.
The program is take a website form with 14 numerical input fields and populate them into an Excel Spreadsheet. The data from the forms is subdivided by sales rep and the input fields (dials, contacts, presentations, etc.) are added. A new sheet is started each week.
The bug is that Excel is not correctly creating the new sheet for the new week. There should be one sheet created for each week of 2019, 2020, etc. What is occurring is that Excel creates the new sheet, pulls all the past data into the new sheet and deletes all old sheets. So all data is combined.
Attached is the current output. You'll have access to the all files.
When you get the program debugged, you'll load it into my computer and test it to ensure it works. Also, I hope you can add to it so the program will not break if someone ever enters something besides a number.
Below is the first project...
Hello,
I have a Wordpress website using Gravity Forms. Each time someone submits a form, it is emailed.
Daily, I have someone retreive the emailed forms, tabulate the data (about 10 tabs) from the forms and add the data by hand into an Excel spreadsheet.
I would like to automate this so the data from the forms is electronically added to a spreadsheet as soon as the fo