In Progress

Microsoft Excel and VBS Expert Needed to Make Automated Quote Forms

We will need 3 spreadsheets for user 1, user 2, and user 3. They must be compatible with Excel 2003. When each user opens the Excel document, an automated date-based title must be generated.

There are 2 cells in each spreadsheet that must be updated automatically based on that day's date and a two-digit number for each new document of the day.

When the user saves the file, it should save by default with that automated date-based title.

More details are provided in the detailed description below, and the Excel documents needed to complete the project are attached.

Thank you!

## Deliverables

We will need 3 spreadsheets for user 1, user 2, and user 3. They must be compatible with Excel 2003.

When these users open Excel, they will begin work in a spreadsheet with a title representing the current month, day, and a designated number for each user.

User 1's spreadsheet will be titled [url removed, login to view]

User 2's spreadsheet will be titled [url removed, login to view]

User 3's spreadsheet will be titled [url removed, login to view]

("Month" and "day" above represent the month and day that Excel is opened by the user.)

By default, when the user saves the document, it should be saved with this title above.

When the user opens the B&BExcel [url removed, login to view],

Field L6 needs to update to the current date each day.

Field L7 needs to be month day (xxxx) followed by a two-digit increment for each new document for the day.

So today it would be 110501, then 110502, then 110503.

Tomorrow it would start with 110601, then 110602, etc.

The Excel files needed to complete this project are attached.

Skills: .NET, Script Install, Visual Basic, Visual Basic for Apps

See more: automated quote excel, xls excel expert, microsoft number, microsoft excel spreadsheet, make a quote, file excel expert, expert with excel, expert in microsoft excel, excel 0 to expert, be expert in excel, microsoft excel forms vbs, Microsoft work, microsoft spreadsheets, excel sheet expert, spreadsheet microsoft excel, save to excel, microsoft excel, excel work today, microsoft visual expert, excel update net, vbs user, excel digit, xls visual basic, sheet excel visual basic, net spreadsheet

About the Employer:
( 178 reviews ) Dallas, United States

Project ID: #2789594

Awarded to:

excel4engineers

See private message.

$10 USD in 14 days
(13 Reviews)
3.4

6 freelancers are bidding on average $66 for this job

vilgilsoft

See private message.

$80.75 USD in 14 days
(10 Reviews)
4.1
nikitasvw

See private message.

$15 USD in 14 days
(54 Reviews)
4.1
alexitkin

See private message.

$250.75 USD in 14 days
(16 Reviews)
4.0
eugene2006

See private message.

$17 USD in 14 days
(3 Reviews)
3.1
petrovp

See private message.

$24.65 USD in 14 days
(4 Reviews)
2.5