With Excel 2003, I want to use a single row for data entry and have the data saved to a Excel table on another tab. When the row is complete, the user clicks "submit" and the data row info is added to the other table.
This way I can design a single entry page, nicely formatted, and when the data is entered to the user's satisfaction, it is stored upon submission out of sight. From the stored data Pivot Tables can be generated or graphs displayed.
Any ideas?
John
Bookmarks