I have 6,000 row x 15 column excel file.  There is 1 field in each row that needs to be updated.  I would like to present a form to the user displaying all of the other fields and asking them to update the one field.
They should then be able to save the update and move to the next blank record.  (There are records (rows) where the data is updated, so the code would have to search through the rows to find the next row with a record (field) that needs to be updated.

I would also like to have the ability to select a "No Update" button that would update a different column in the event that a user was not able to update the record due to lack of information.

The automation should also write back to a new column a timestamp of when the record was updated.  (OPTIONAL: have the user enter their initials into the user form so I could also track who updated the record.)
There will be multiple people using this form so it is possible that two or more people would have the workbook open at one time.
Ideally, this would be able to work in either desktop Excel or Ecel in a MS Teams web interface.

Hourly Range: $22.00-$50.00

Posted On: July 19, 2024 19:10 UTC
Category: Scripting & Automation
Skills:Scripting, Spreadsheet Automation, Excel Macros, Visual Basic for Applications, Database

Country: United States

click to apply