i need a macro created for excel to retrieve prices of my items based on an excel sheet.
Our items are categorised by model codes. So when I key in a model code (or select from dropdown box), it should show the price of it line by line.
Each line should have the output as below:
A. Model code B. Parts Name C. Price per piece D. Qty (depending on user input) E. Total price
The reason why i would need this macro or formula done is so that I don't have to hit the CTRL+F to lookup for prices and fill it line by line which is very tedious.
I have attached a file of what i would desire the output to be.
Bu iş için 11 freelancer ortalamada $26 teklif veriyor
Dear Sir/Madam, I have 4 years experience in Excel VBA programming including automated data extraction from websites. I used to work at Ford where I created tools that scraped competitor prices from their websites. Daha Fazla
Hi, I can finish this job in under 2 hours with high quality. This is a pretty easy job so paying more than $20 would be too much.
Hi, I can do this job in a professional manner. I can assure you to provide 100% accurate work. Please contact with me. Although I am new here! I will try my best to provide you quality service. Please send me more det Daha Fazla
Dear Sir/Madam, Thank you for this wonderful opportunity. I am keenly considering your job post including these skills.I am working as team leader in A4Logic it is software and web solution company we are operati Daha Fazla
Dir Sir/Madam Could you give me a try ? But you have to provide to me the main sheet. Thank you very much.
I am working on weekends. The project will be delivered in one day with all requirements as per your need.