The "Update DB" macro of the attached spreadsheet needs a minor update.
If you enter data and click "Submit Data" it seems to work fine. There is a problem when you delete the current (dummy) data and start entering new info in the "Checklist data" tab.
When you submit new data from scratch it appears in row 6 of the "Data" tab instead of row 5.
The issue is in line 14 of the macro. Specifically the formula for "LR". It needs to be updated so it works for a blank sheet.
Should be a simple problem to fix for someone with VBA experience. Will pay £20 rushing charge if complete within 12 hours.
10 freelancers are bidding on average £59 for this job
HI expert here for VBA .Lets start working without wasting a time with great accuracy and time dead line. My aim is to satisfy my client by my work Thanks
Buenas tardes, Será un placer colaborarle a corregir su macro. Por favor, contacteme por chat para discutir mejor su proyecto. Saludos cordiales, Luis Romero
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards