In Progress

excel expert needed for invoice

Hi,

(PM me for the files - i don't want to post up).

I have 2 forms, once i use to generate quotations for projects, another i use for generating invoices when project is completed. It is time consuming to cut and paste especially when i have 4-5 projects a day.

I need someone to combine these 2 forms into 1 excel file, with 2 sheets, so that i can easily update 1 first sheet with the fields and both quote and invoice sheets will have the same information. If possible, it has to allow for calculation also and allow me to add more or less PROJECT DETAILS. e.g. some projects have 2 parts, some have 6 parts.

Also it has to auto fit A4 page and be smart enough to extend to 2 A4 pages if the project descriptions are long (many items). I usually print to PDF and email to my clients.

It also has to auto update the date based on the format i provided and generate the project ID which is YYYYMMDDHH e.g. 2008011413 (HH is in 24hr format).

Let me know if you bid is less than $30 (in PM) and i'm open to any suggestions.

Thanks

Skills: Data Entry, Data Processing, Excel, Windows Desktop

See more: sheets add, me excel, need pdf expert, file excel expert, n excel, less excel, excel less, excel sheet expert, pdf invoice, invoice, invoice processing, id provided, hh, format excel, expert excel, excel projects, excel calculation, excel based, combine excel, file cut paste, cut paste file, combine pdf files, needed auto, excel pdf fields, pdf combine files

About the Employer:
( 321 reviews ) Singapore, Singapore

Project ID: #225306