Đã hoàn thành

Excel Macro to calculate selling value by FIFO method

Excel Macro to calculate selling value by FIFO method

Create an excel Macro to analyze transactions and calculate the selling value of each asset using the FIFO method.


1. “History” Worksheet –All transactions recorded by date. The macro should calculate the sell values of the asset according to FIFO method.

2. “Inventory” Worksheet - Shows the remaining amount of each asset.

See the excel example.

It should be able to handle big amount of trades and assets.

Kĩ năng: Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: create an online database for teachers of disabled children the database is almost ready i am curently using participants databa, excel vba macro calculate working hours, java create method calculate entire value, excel macro calculate travel time, calculate lifetime value customer excel, macro find copy value find sheet excel 2007, excel macro calculate spreadsheet, macro calculate area bounding line excel, excel vba sum based value column, excel vba calculate critical path, excel formula calculate staying nights, php form calculate select value, design database using fifo method sql, excel 2007 calculate savings, example excel macro vba invoicexls forum, fifo method used invetory vbnet, excel vba macro calculate business days

Về Bên Thuê:
( 2 nhận xét ) Donostia, Spain

ID dự án: #16728998

Được trao cho:


I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. Your task is clear to me and I am ready to execute the project for 30 USD for 1 day.

$30 USD trong 1 ngày
(61 Đánh Giá)

17 freelancer đang chào giá trung bình $35 cho công việc này


"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Thêm

$70 USD trong 1 ngày
(158 Nhận xét)

- Went through the FIFO worksheet and the History and INventory tabs. - Based on the daily transactions purchase or Sales of a particular SKU the costing and selling prices and the items sold on ongoing basis can calc Thêm

$100 USD trong 3 ngày
(51 Nhận xét)

Hello, I am experienced excel profesional. I can help you with this. Looking to hearing from you. regards

$30 USD trong 1 ngày
(51 Nhận xét)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Thêm

$30 USD trong 1 ngày
(24 Nhận xét)

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. In one of the macro i Thêm

$88 USD trong 2 ngày
(15 Nhận xét)

I am proficient with excel macro/VBA development, I can write the code to read data from sheet 'History' and generate report as per specified in sheet 'Inventory', if you are interested feel free to message me, looking Thêm

$20 USD trong 1 ngày
(45 Nhận xét)
$25 USD trong 1 ngày
(39 Nhận xét)

Hi Nice to meet you. I have rich experiences with Excel VBA and I'd completed a lot of projects. Your project seems to be simple, so I think i can do it in short time. You might visit my profile to confirm my sk Thêm

$25 USD trong 1 ngày
(7 Nhận xét)

Hello, Thank you very much for this FIFO method expart Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can Thêm

$15 USD trong 1 ngày
(9 Nhận xét)

This work will best for me because i am experienced in this field our experience will great ever. I am a Programmer & Graphics Designer

$22 USD trong 1 ngày
(0 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)
$30 USD trong 2 ngày
(0 Nhận xét)

please send the file, I can do the project with excel visual basic. Even if you want to automate printing out, it will be done within a day.

$25 USD trong 1 ngày
(0 Nhận xét)

I can do your project efficiently and in time ...... I will be grateful if you see my profile... thank you

$10 USD trong 1 ngày
(0 Nhận xét)

I can work on excel and do my job following the deadline. Relevant Skills and Experience I know how fifo [login to view URL] since I have been in manufacturing industry for 3 years. I can work on it for you

$25 USD trong 1 ngày
(0 Nhận xét)

I have done this in past. Can hel you witb this if you share the details with me

$30 USD trong 3 ngày
(0 Nhận xét)