I have an excel to input data, and I need some calculations.
In order to do that, this excel needs to be converted in access database, each sheet must be a table for inputting data.
Then I need 4 dropdown list to extract information for 1 day, 1 week, 1 month or 1 year.
Information will be shown in a report, (1 page)
Calculations are sums of kilos, scrapt, stock and % of consumptions related with input tables.
I can provide a video explanation, and excel source file to be converted in ms access database.
46 freelancers are bidding on average $143 for this job
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.