Create an Excel Template and macro
$20-50 USD
Płatność przy odbiorze
I need an Excel template created with macros or Visual Basic Tools that execute the copy, paste and file-save functions described below.
The worksheet, "[login to view URL]" accumulates and processes data entered into an online form. Zapier connects Gravity Forms to this worksheet. When a new form is submitted in Gravity Forms, the data is automatically added to the "Zapier Sheet" in the Excel file as a new row.
When a new row is added by a form submission to "Zapier Sheet", I want that row to be copied to the "Template 1" sheet, added as a new row just under the field names.
I need to be able to mark any entry/row in the "Template 1" sheet for selection and saving to a new text, tab-delimited file that includes the field name row.
I expect that by marking a row in the "Select" column and activating a macro, the row of data will be processed and prepared for saving as a tab-delimited text file. Attached to this description is a sample output file, "PQ008 David Jones [login to view URL]"
File name should be composed of the following fields: [Unique ID] [Lic Name (First)] [Lic Name (Last)] [Date of Export]
Numer ID Projektu: #13597842
O projekcie
Przyznany użytkownikowi:
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
7 freelancerów złożyło ofertę za $63 w tym projekcie
Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Good day, I am Luis from Venezuela and it will be my pleasure to help you with your excel file. As you could see on my reviews I am an excel and macro developer. Please contact me by chat and then we could discuss Więcej
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I have al Więcej
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Więcej
I will help you in your work I assure you for the quality work , i am new here but you can trust me for quality work