I needs to get the final result file which I attached as a sample (1 April)
The process starts like this
I upload daily price file (sample Daily price list 1 April) in which you have Art No. which is unique and the cost price of the products. On the basis of those cost prices; the prices further calculated with the help of a Macro enabled price calculation file (Sample Price Calculation Formula)
Upon getting the results in Excel file with calculated prices; we copy paste all the data in another file ASIN Search file (file attached) and this file calculate the ASIN through macros.
Once we got both calculated prices and ASIN then we enter all the details in the Final File (1 April) and apply following formulas
1. Conversion of currency up to 3 digits after decimal and get the result in column H
2. Reduce the price 0.5 from the above result and show in column J
3. Add the price 10 of column H and show in column L
3. and the rest of the values simply copied from the previous resultant files of price calculation and ASIN files.
So this is the process which we are following everyday. Now what we want is that
We upload only Daily Price list file and the rest of the calculations should be done automatically and gives me the option to download the final file (1 April).
I should have option to upload whenever it is necessary the revised Master File ASIN and Price calculation file along with the option of entering the currency value such as 0000.738
The whole purpose of this is tor reduce the steps which I have to perform on a daily basis so I am open to any solution no matter it is web based or desktop solution or even within some VB program or any other option.
11 pekerja bebas membida secara purata $107 untuk pekerjaan ini
I propose to write c# based application to perform all tasks. I am experienced developer with c#. I can help you with task. Looking to hearing from you. Regards ,
Dear Hiring Manager, I have related expertise for article writing and can deliver the best in next 1 hour. I will make send you the best output and will share the ideas with you. Let us discuss about the project