Project Detail

Convert spreadsheet/workbook from Lotus123 to Excel 2003  

Convert spreadsheet/workbook from Lotus123 to Excel 2003 is project number 420351
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: encha

Budget: $30-250

Created: 04/17/2009 at 17:26 EDT

Bid Count: 14

Average Bid:
N/A

05/17/2009 at 17:26 EDT

Project Creator: emscosupport
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (14 reviews)

Bid On This Project
 

Description

Existing Lotus123 workbook has (4) imbedded lookup tables and macros. When opening up “Vouch Master” file in Lotus, lotus prompts for “Invoice Number”, “Account Number”, “County” and then using the macro/lookup tables, inserts information into invoice sheet. The user inserts codes into invoice area that pulls information from the lookup tables and calculates cost/tax information for each line item. All of the same functionality/macros need to be present in the final Excel spreadsheet.

A few alterations to present functionality need to be added/changed in final Excel spreadsheet.
1. Additional input prompt when opening for "State" and when it equals Texas, tax=6.25%, Oklahoma=4.5%.
2. Inside invoice description, word wrap before over-running boundaries for cell to next lower cell.

Files Attached:
Vouch_Master.123 – Master Lotus123 File with Macros/Lookup Tables
InvoiceExampleA.123 – Master file that has been renamed after information inserted into invoice.
InvoiceExampleB.123 – Master file that has been renamed after information inserted into invoice.

The finished product will be examined by my accounting person before payment is finalized.

Thanks for looking.


Additional files submitted:
VOUCH_MASTER.123
InvoiceExampleA.123
InvoiceExampleB.123

Messages Posted:5 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


    Bid on this Project