Forum Discussion
How to make a form to fill the first blank row instead of the first row of a table.
In Excel forms, when selecting the forms options and entering the data, the data is entered in the first row of the table. I need the form to enter the data from the blank row of the table so that th...
Thank you for your reply. I have attached the worksheet of the form and attached the trouble that I am having.
The vba code is not saved in this document but in E:\Work documents\OneDrive - Quest Pharmaceuticals Pvt. Ltd\Work documents\Performance appraisal and Operations management\Draft for the activities and task list-macro enabled.xlsm'!New_data_entry
First you sould include the code into your actual file.
Also I don't really understand the requirement that you mention in the file, sorry
First you sould include the code into your actual file.
Also I don't really understand the requirement that you mention in the file, sorry
Thank you for your quick response. I have attached the updated file. Hope you understand my requirement. I have only used a macro and not edited the code of the macro.
- What excel version are you using?
- MS Excel 2020 version 14.0.4734.1000(32 bit)