Index finger pointing up icon

From: Poland

Location: Lublin, PL

On Useme since 14 April 2019

Business bag icon

Deals 1

SUCCESSFUL: 1

DISPUTED: 0

FAILED: 0

Skills

Bookkeeping English Excel Finance Payroll

CV / Résumé

Jun 2015 - Dec 2023

księgowy, kadrowy, backoffice

Niejawne

Completed offers 1

  • Excel spreadsheet A document consisting of multiple worksheets.... Sheet1 is the mother sheet. It is a list of all the intermediates from which products are made. All the names codes and prices are there. The prices will be updated there. column A- Name column B- Internal code column C- Price per ingredient column D- Notes The next worksheets are the worksheets where the cost of each product will be calculated. In these worksheets, I want that when I enter the name, the code and price will be completed according to worksheet1 and at the same time that when I enter the code, the name and price will be completed according to worksheet1. Also, so that when I change the price in sheet1, it automatically changes in the other sheets. The second function is that column F (cost of the item) should show the product of columns CxD (price per component x quantity = cost of the item) column A- Name column B- Internal code column C- Price per component column D- Quantity column E- Item code column F- Cost of the component It would be good for the sheet to work also in older versions of Excel (Excel 2013) I am asking for offers to create such a sheet