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=[url removed, login to view]%, 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, lotus 123 excel, lotus 123 excel 2003, lotus 123 conversion excel, tax accounting information, spreadsheet accounting, need cost accounting, master accounting, cost accounting spreadsheet, 123 excel2003, lotus 123 converter excel, excel lotus 123, excel 2003 lotus 123, macros lotus 123, convert lotus123 word, lotus 123 convert, lotus 123 macros, excel convert 2003, excel 2003 lotus, convert lotus excel notes, copy paste excel, master excel, word convert, spreadsheet input, spreadsheet excel accounting

About the Employer:
( 17 reviews ) Oklahoma City, United States

Projektin tunnus: #420351