Hi,
I need help with the workbook I'm developing. I am creating a data entry form for users who have little to no knowledge of Excel. Currently, the workbook is set up so the user would enter text in a cell then click on a form button to take them to the next step. I need to create an additional macro so that the text entered in steps 1-2 is transferred to the next free row for the corresponding cell in the table in sheet - step 3 and then cleared from the cell field.
The workbook is attached. The goal is to have a user do this monthly with new data and never see the table itself just the resulting chart, so they can't break the table programming.
Any help would be great.
Bookmarks