В работе

VBA Script Produce Batch Documents in Excel

VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template

NOTE "Outline formatting would not paste into Freelancer Table"

Need this weekend.

• Availability- Must be Immediate.

o We have to turn in documents for a job we completed by Sunday afternoon

• Overview

o VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template

o Need for the current Project

 So other requirements for the VBA that would generally be needed can be skipped

• Such as pulling in Job info, client info, location info, subcontractor info, etc…

• Rough Draft Structure (can be changed)

o SOS Sheets- Producing multiple SOS (sign-out Sheets)

 Template for all SOS is the same

• Job Info, spot for manager to sign/print name and add store stamp, Legal e’s

• Some SOS will need to be multiple pages

 these SOS sheets will have items populated to it based on the date range selected in the ENTER SHEET

• Table for SOS info- SOS #, Date range, Pg #

• Table for Job Items populated within the date range

• Table for a Daily summary for # of techs onsite and start and end times for that day

• Table for the SOS File Name

o ENTER SHEET

 for entering the information to populate the Batch SOS Sheets

• Table

o We can enter a starting # for SOS

o Job Part Info (for making file names for each SOS generated

• Multiple Tables- for each SOS to be produced

o Enter the start date

o enter the end date

o populates the items completed during the range

 we can edit the list or add other items numbers to it

Квалификация: Excel, Excel VBA, VBScript, Visual Basic, Visual Basic для приложений

Показать больше start vba script excel, run vba script excel, data oracle batch using excel vba, run batch file from excel button, excel vba create and run batch file, create file excel vba, how to create a batch file in excel macro, how to create batch file using vba, excel vba run batch file, run excel macro using batch file, run excel macro from batch file, excel vba script modify existing vba, vba script excel xml, vba script excel current worksheet, vba script project excel, can vba script run outside excel, simple excel vba script, excel using custom vba script, excel vba script find text, excel nearest neighbor vba script

О работодателе:
( 1 отзыв ) Garner, United States

ID проекта: #18514060

Поручен:

dvcontact

Hi, You may not select the right candidate without knowing what your project on building a VBA Script in Excel to take information based on date ranges, from 3 different sheets, and produce batch documents with the sa Больше

$300 USD за 3 дней(-я)
(42 отзывов(-а))
6.0

6 фрилансеров(-а) в среднем готовы выполнить эту работу за $390

mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will build you a macro that will take information from the excel sheet and then will build a batch document. I have been in this industr Больше

$250 USD за 1 день
(58 отзывов(-а))
5.7
gr8tech

Hello there I have gone through your project requirements and I am available to develop the VBA script to automate the creation of the required documents. I am available to start now and would like to discuss with you Больше

$500 USD за 1 день
(37 отзывов(-а))
5.0
lightingdavid

Hello? Outline formatting would not paste into Freelancer Table How are you? I have good experiences in "VBA Script Produce Batch Documents in Excel" as you can see my profile for these (Excel, Excel VBA, VBScript, Больше

$400 USD за 1 день
(25 отзывов(-а))
5.0
rickygzz85

I have more than 20 years of experience using Excel to its maximum capabilities. I offer - Availability to work full time on this project, to meet the deadline. - Your satisfaction is 100% guaranteed. - I will s Больше

$500 USD за 2 дней(-я)
(13 отзывов(-а))
3.2
Digyasoni

Hi there, I have seen your project description and understood it. My offer - Competitive price Quality work Free support and maintenance On time delivery Responsive updates

$388 USD за 3 дней(-я)
(0 отзывов(-а))
0.0