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?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Saving data from a form
0
Answers
0
Selected Answer
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?
Discussion
thanks for your answer
can you be more explicit about your hypothesis that i use a TOTALS ROW , honnestly i dont know what iti is
when i create the Table i just let Excel do it
can you be more explicit about your hypothesis that i use a TOTALS ROW , honnestly i dont know what iti is
when i create the Table i just let Excel do it
robertpellan (rep: 4) Nov 7, '20 at 6:03 pm
The Totals Row is an option for a table, you have to add it. Follow the steps that I mention in my answer and tell me how that works for you.
don (rep: 1989) Nov 7, '20 at 6:53 pm
thnaks you it work very well now
robertpellan (rep: 4) Nov 8, '20 at 12:35 pm