Forum Discussion
Solved
Required help to link to spread sheet using userform
hi all,
I am very new to VBA coding features . My company given me database spread sheet in which there are about more than 150000 lines in that sheet.
So i need a user form to retrieve the data ...
- That is incorrect, you can use the Find buttons to find an existing record and edit it and use the criteria button to actaully search in the data. The Criteria also accepts wildcards.
Thanks for the response yes i saw that data form features, but it create new data. but for me i have already have more than 150000 lines in a sheet(which company provides) so i have to retrieve the data of a particular employee and update his details and save.
That is incorrect, you can use the Find buttons to find an existing record and edit it and use the criteria button to actaully search in the data. The Criteria also accepts wildcards.
- Thanks what you have said is correct. We can do. but i have a very vast data to be update in the excel with less time, For example 4000 employees 30 days time sheet with their present and absent and with Overtime details has to updated in the Excel within two weeks. so if i have a particular employee's time sheet for one month from the database spreadsheet (as illustrated above) so i can update the records very easily.
- If you have to update many records I would say editing them directly in the table is probably by far the quickest way. Use the filtering capabilities of Excel to filter the table.