Create google sheet script/formula
$10-30 USD
Paid on delivery
We need a solution to process our sales data from different countries.
Our Google Spreadsheets are being populated by mailparser ([url removed, login to view]), which populates different cells based on the country the sale was made, but we need to run some formulas based on the amount sold to determine profit, costs,etc. But the new entries skip any line which has any formula. We need a solution for this issue, so we would have the other fields such as profit, costs and margin automatically populated based on the new entries sent by mail parser.
Additionally, we would like to create a pivot tables for each country and a single one showing total numbers. Feel free to ask more in case of any doubts.
Project ID: #13966287
About the project
Awarded to:
I think Some macros along with scripting (maybe python) can fix your issue. The issue is arising due to multiple definitions to the cells which are misleading the data as and where to store it. Allow me to look into t More
7 freelancers are bidding on average $23 for this job
Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of parti More
Turning Dreams Into Reality !! ♦ COMING is a beginning ♦ KEEPING together is progress ♦ WORKING together is success. *Our solution will always give you a great success. Your success is our SUCCESS. More
Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More