We are using an excel workbook as a form for users to populate 10-12 key data points. Then the data is used in a second worksheet in the workbook. Using formulas on the second sheet, the data is manipulated to create standard naming conventions and populate other fields to formulate a "slate". The slate uses about 10 cells to reformulate the information from the form sheet into a certain order. The populated slate fields contain information on how to configure a "video slate" which is used in post production to identify the content after it. Currently the operator manually translates the slate data from the printed version of the excel into a software interface. We would like to have a macro that takes the slate data and saves it to a text file that can be used to programatically derive the slate information (rather than having the operator manually type the information). The text file would need to be saved to a Sharepoint document library, with some specfic information from the slate used to name the text file. The macro would be manually triggered by the user filling out the form. The macro should be configured to allow automatic triggering at a later date (for example, when the user selects the "print").
17 freelancer đang chào giá trung bình $97 cho công việc này
Hello. Creating Macro in Excel is the job we are good at. Please assume high quality work with a precise attention to details. Check your inbox for examples.
Hi, I would love to provide you with a WORKING SAMPLE for review. In order to give you that, I request you to provide some more details. Kindly refer PM.
I have over 10 years experience working with Excel VBA and SharePoint. I can automate this task for you and include the ability for either manual or automatic conversion based on whatever logic you would like.
I have a great ability in data entry and excel spread and my focus when doing any job is excellence. Excellence is the only sure path to attain success. I also put in mind the satisfaction of my employers.