A macro for a excel file
- or -
Post a project like this3209
£50(approx. $60)
- Posted:
- Proposals: 41
- Remote
- #308317
- Awarded
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis

DataWarehouse,SSIS SSAS SSRS ,MSBI Developer, Datamining,BI Architect,DW Architect
51315035495561407738090327117272146385195397218135251965361516377785





Description
Experience Level: Intermediate
I am not sure if this is possible to do but wondered if you may be able to help.
We have listings on eBay , each listing has a listing number and a custom label number.
We need to update our stock on a daily basis by creating a excel file.
The problem is we have to use the eBay listing number to update the stock but the report we get from our supplier only gives the custom label number.
I have attached a sample Ebay update file and a sample stock file.
Is there a way of updating the sample eBay file using the stock file by excel searching for the custom label numbers and then updating the stock quantity, perhaps some kind of macro ?
I hope you can understand my rambling ! LOL as I realise its a bit difficult to explain.
Many Thanks
We have listings on eBay , each listing has a listing number and a custom label number.
We need to update our stock on a daily basis by creating a excel file.
The problem is we have to use the eBay listing number to update the stock but the report we get from our supplier only gives the custom label number.
I have attached a sample Ebay update file and a sample stock file.
Is there a way of updating the sample eBay file using the stock file by excel searching for the custom label numbers and then updating the stock quantity, perhaps some kind of macro ?
I hope you can understand my rambling ! LOL as I realise its a bit difficult to explain.
Many Thanks

Mark J.
100% (2)Projects Completed
5
Freelancers worked with
5
Projects awarded
7%
Last project
29 Dec 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy