Đã Hủy

Simple spreadsheet macro project

I have a spreadsheet (it's LibreCalc rather than Excel) with a list of items that I use to shop from an online wholesaler. I have a master list of the things I order, I delete the items I don't want this time, and the sheet totals my order at the bottom. But the wholesaler updates its prices monthly, and publishes them in a different spreadsheet. Each month I have to search his spreadsheet for the items on my list (which have both a name and a product code - I search by product code), and then manually copy the updated price into my spreadsheet.

I've attached examples of both spreadsheets.

I suspect that a competent spreadsheet user could write a macro or a function that would update the numbers for me automatically from the new price list. I am happy to rename the price list spreadsheet (each new one has a new name to refer to the month) if this makes it easier to do.

Kỹ năng: Tài chính

Xem thêm: macro excel librecalc, write name items online, simple spreadsheet examples, spreadsheets online, simple macro, macro, macro excel, finance simple, spreadsheet price list, write macro, finance excel macro, excel finance project, simple makes, project macro, macro spreadsheet, update excel sheet code, online spreadsheet excel, update spreadsheet macro excel, online spreadsheet, product project excel, spreadsheet update manually, excel update macro, finance excel spreadsheet, master excel sheet, excel macro simple

Về Bên Thuê:
( 0 nhận xét ) London, United Kingdom

Mã Dự Án: #1710892

9 freelancer đang chào giá trung bình £69 cho công việc này

javed1705

Dear sir, plz check pm

£50 GBP trong 1 ngày
(47 Đánh Giá)
5.3
KarrarRaza

Financial Analyst at your service. Please refer to inbox for details.

£50 GBP trong 3 ngày
(10 Đánh Giá)
3.9
Krusche

Our offer is to create a concise professional application for you to automate the process you describe.

£180 GBP trong 7 ngày
(0 Đánh Giá)
0.0
Elfish11

Hi, I have read your project carefully and I can guarantee you that it will be done with up-most quality. I am proficient in VBA(macros)in Excel and have good financial knowledge. Please do forward the spreadsheets. Thêm

£48 GBP trong 1 ngày
(0 Đánh Giá)
0.0
Imtiaznizar

Hi Sir, I can perform your work up to your requirement. I have qualification also for performing the same. Give me a chance to prove my self. Waiting for your reply. Thank You

£100 GBP trong 6 ngày
(0 Đánh Giá)
0.0
ASUExcel13

Please select me if you want this done correctly.

£40 GBP trong 0 ngày
(0 Đánh Giá)
0.0
bhamani86

Hi am an accountant i do this kind of jobs everyday i have good control in spread sheet i also have three years of experience working with UK based company

£40 GBP trong 2 ngày
(0 Đánh Giá)
0.0
PEPH7

I work in LibreCalc Finance is a strong point of mine My work is accurate To meet deadlines is important for me

£70 GBP trong 5 ngày
(0 Đánh Giá)
0.0
CompuIIT

Am an expert in Excel based VBA scripting and programming. I will be able to complete this project in less than 2 days.

£45 GBP trong 2 ngày
(0 Đánh Giá)
0.0