Create an Excel Template and macro

Tamamlanmış İlan edilme: 6 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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

Proje NO: #13597842

Proje hakkında

7 teklif Uzak proje Aktif 6 yıl önce

Seçilen:

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.

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(292 Değerlendirme)
7.2

Bu iş için 7 freelancer ortalamada $63 teklif veriyor

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 in 4 gün içinde
(300 Değerlendirme)
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 Daha Fazla

$45 USD in 4 gün içinde
(110 Değerlendirme)
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 Daha Fazla

$49 USD in 2 gün içinde
(44 Değerlendirme)
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 Daha Fazla

$55 USD in 3 gün içinde
(49 Değerlendirme)
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 in 10 gün içinde
(0 Değerlendirme)
0.0