Convert spreadsheet/workbook from Lotus123 to Excel 2003
$30-250 USD
Em Andamento
Publicado há aproximadamente 15 anos
$30-250 USD
Pago na entrega
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.