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.

Taidot: Rahoitus

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) London, United Kingdom

Projektin tunnus: #1710892

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Dear sir, plz check pm

£50 GBP 1 päivässä
(47 arvostelua)

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

£50 GBP 3 päivässä
(10 arvostelua)

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

£180 GBP 7 päivässä
(0 arvostelua)

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. Lisää

£48 GBP 1 päivässä
(0 arvostelua)

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 6 päivässä
(0 arvostelua)

Please select me if you want this done correctly.

£40 GBP 0 päivässä
(0 arvostelua)

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 2 päivässä
(0 arvostelua)

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

£70 GBP 5 päivässä
(0 arvostelua)

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 2 päivässä
(0 arvostelua)