Create an Excel Template and macro

Ukończone Opublikowano 6 lat temu Płatność przy odbiorze
Ukończone 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]

Excel Microsoft

Numer ID Projektu: #13597842

O projekcie

7 ofert Zdalny projekt Aktywny 6 lat temu

Przyznany użytkownikowi:

P0L

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.

$50 USD w ciągu 2 dni
(292 ocen)
7.2

7 freelancerów złożyło ofertę za $63 w tym projekcie

schoudhary1553

Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

$150 USD w ciągu 4 dni
(300 Oceny)
7.8
beltran0404

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

$45 USD w ciągu 4 dni
(110 Oceny)
5.4
sonarkaushik

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

$49 USD w ciągu 2 dni
(44 Oceny)
5.5
prabakarm23

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

$55 USD w ciągu 3 dni
(49 Oceny)
4.6
znawaz97

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

$55 USD w ciągu 10 dni
(0 Oceny)
0.0