Đã 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 nhiều hơn: macro excel librecalc, write name on items online, simple spreadsheet examples, spreadsheets online, simple macro, macro, macro excel, 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

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

ID dự án: #1710892

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


Dear sir, plz check pm

£50 GBP trong 1 ngày
(47 Nhận xét)

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

£50 GBP trong 3 ngày
(10 Nhận xét)

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ận xét)

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ận xét)

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ận xét)

Please select me if you want this done correctly.

£40 GBP trong 0 ngày
(0 Nhận xét)

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ận xét)

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ận xét)

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ận xét)