My question is about Excel - Part 5 - Save Data from the Form. It works fine but I want to export the data to an excell table and oddly the copy is done at the end of the table and not in the table .. what to do?
My question is about Excel - Part 5 - Save Data from the Form. It works fine but I want to export the data to an excell table and oddly the copy is done at the end of the table and not in the table .. what to do?
You must have made your Table incorrectly because I just downloaded the file for Part 5 and went to the Data tab and clicked in the sample data and hit Ctrl + T and then Enter to turn it into a table and then filled-out the form on the Form tab and clicked Submit and it worked just fine.
Maybe you used a Totals Row and that caused the issue becuase the new data was then put below that row?