Create an Excel Template and macro

完了済み 投稿 6年前 着払い
完了済み 着払い

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]

エクセル マイクロソフト

プロジェクトID: #13597842

プロジェクトについて

7個の提案 リモートプロジェクト アクティブ 6年前

アワード:

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 2日以内
(292レビュー)
7.2

7人のフリーランサーが、平均$63 で、この仕事に入札しています。

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 4日以内
(300件のレビュー)
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 もっと

$45 USD 4日以内
(110件のレビュー)
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 もっと

$49 USD 2日以内
(44件のレビュー)
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 もっと

$55 USD 3日以内
(49件のレビュー)
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 10日以内
(0件のレビュー)
0.0