excel form project


(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.


Skills: Excel

See more: project excel forms, excel form project, project update form excel, project form excel, form project excel, sheets add, m format in excel, me excel, excel &, cut excel project pages, cut paste invoice form, update excel form, n excel, less than excel, excel less than, update project, Project m, project id:, project ID, print&cut, invoice/quote, id provided, hh, forms to excel, format excel

About the Employer:
( 324 reviews ) Singapore, Singapore

Project ID: #213383