I need an excel form to edit data in an excel spreadsheet. Rows hold metadata regarding files in a document library.
What I am looking for is independent of of the actual content of the data,
Except that you need a column to hold the file path and a column (or morre) to hold a flag regarding what needs to be happening with a particular row.
Had this been MS access, this would be a 1 min project.
All this needs to do is to enable user to edit rows in a form format
a bit like this
The only little issue is that not all fields need to be editable in the form. Therefore, you would some kind of config area to limit what fields are needed.
so for example, clicking column A in a given row would load the editable fields of that row and allow and save it when done.
Just so I know we are on the right track, let me know if you understand what I am describing and please evaluate how long it would take.
Please note that I need this right away, therefore only apply if you can work immediately.
Also make sure the first word of your reply is EX03 (otherwise I will not even read your application)