I need someone really excellent in Excel and particularly MACRO /VBA.
I need to create a DATABASE for the Quotation I receive from my suppliers.
Internally I receive "DEMANDS OF QUOTATION" from someone (in Excel Format).
I need the DATABASE to have some kind of a system (a button for example) to IMPORT the demand I receive in Excel format.
the DATABASE will automatically "absorb" the demand and feel its cells according to the information that are in the demand.
The "DEMAND OF QUOTATION" has a Standard form.
The DATABASE has a standard form.
Once I have imported AUTOMATICALLY the information from the excel document called "DEMAND OF QUOTATION" into the DATABASE, I will then clal many suppliers and asked them for their prices.
Everytime I receive a price from a supplier I will fill in that price into the DATABASE in the ROW that corresponds to the DEMAND OF QUOTATION I am working for.
Once I have finished filling the prices from the suppliers into the DATABASE, I need to be able to select the line in the DATABASE that now I want to EXPORT into a STANDARD FORMAT (standard document) called "QUOTATION RESULT".
= the DATABASE will generate that standard document QUOTATION RESULT with all the same information that were in the DEMAND OF QUOTATION + the PRICES + some more information.
I need someone REALLY EXCELLENT TO DO IT VERY FAST
I have attached files:
GRILLE DE [url removed, login to view] = DEMAND OF QUOTATION
BDD BETA V4 = the database
remise tarifaire = QUOTATION RESULT
I need every Quotation imported into the DATABASE to have its own "ID" generated automatically
I NEED IT DONE BY THIS FRIDAY 16/02/2018 - PLEASE BID ONLY IF YOU ARE SURE YOU CAN DO THE JOB YOURSELF BECAUSE WE MIGHT BE WORKING LIVE TOGETHER TO CORRECT BUGS ETC.
Thanks and regards
14 freelancers are bidding on average $126 for this job
I am not a random bidder.. I dont outsource my works.. I have read all the content and I can do this one by EOD tomorrow.. Please ping me if you are interested with my proposal and share more details thank you...