Käynnissä

Convert spreadsheet/workbook from Lotus123 to Excel 2003

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:

[url removed, login to view] – Master Lotus123 File with Macros/Lookup Tables

[url removed, login to view] – Master file that has been renamed after information inserted into invoice.

[url removed, login to view] – 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.

Taidot: .NET, kirjanpito, C-ohjelmointi, tiedonsyöttö, Excel

Näytä lisää: convert lotus 123 excel, convert lotus 123 excel 2003, lotus 123 excel, lotus 123 excel 2003, convert lotus 123 file excel, convert lotus 123 files excel files, lotus 123 conversion excel, tax accounting information, spreadsheet accounting, need of cost accounting, master in accounting, excel macro to word, cost accounting spreadsheet, cost accounting 2, convert 123 files excel 2003, 123 excel2003, convert lotus 123 files excel, lotus 123 converter excel, convert lotus 123 excel online, convert lotus file macros excel 2003, convert lotus excel 2003 macros, excel lotus 123, convertitore lotus 123 excel, excel 2003 lotus 123, convert macros lotus 123 excel 2003

Tietoa työnantajasta:
( 17 arvostelua ) Oklahoma City, United States

Projektin tunnus: #420351