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.
9 freelanceria on tarjonnut keskimäärin 69 £ tähän työhön
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
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