已完成

Create an excel quoting template, which imports and resizes pictures

We are a Childrens' Toy wholesaler located in Brisbane, Australia. We have over 1000 different products, and we often need to create customised quotes. For example, we may identify 50 products we would like to present to a customer. We only want to show them these 50 products, and no others. The 50 products are different for each quote, we create the list in excel.

The end result we are after is a list of product codes, other product information, such as the name and price, and a picture of the product. We can easily generate all of the information for the quote, except for the picture. We currently have to manually import the image. This is where we need help, we are after somebody who can create a template, where we can add the product codes into column A, then the image for that product is automatically imported into column D of the same row, (and ideally set to move and size with that cell).

The pictures will always be in the same folder location, and will be named the same as the SKU name in column A.

See attached example of what we need. Let me know if anything is unclear and needs further explanation.

技能: 数据处理, Excel

查看更多: create hotel directory template, excel app template, create excel database can posted forums, create header email template, create html jpg template, create excel template import data, create excel template import, create excel form template quickbook import, create bank statement template excel format, create excel database will create letters word template, create excel report template, create excel template csv file, create excel file template, Create excel Template, excel inventory template create, create excel survey template, create simple excel spreadsheet template macros, create excel letter template, URGENT: Create box die-cut template with existing pictures

关于此雇主:
( 2个评论 ) Brisbane, Australia

项目ID: #17759216

授予:

paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to automate a process of importing and resizing images located in a specific folder. This is 更多

$250 AUD 在3天内
(155条评论)
6.8

47 威客就此工作平均出价 $384

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( 更多

$333 AUD 在3天内
(637条评论)
8.3
schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you 更多

$300 AUD 在5天内
(286条评论)
7.6
livegoodlife

what i can offer you a desktop software do work like the way you are looking for, do you have a site to get the image for a single product ? even 2/4 sites to lookup the image for ?

$600 AUD 在5天内
(203条评论)
7.8
bpwebanalysts

Hi, I had a look at excel file and I am clear on your requirements. I am ready to send you a sample. Could you please send me over the details? Interested to work on this. Kindly discuss further so that let's get star 更多

$250 AUD 在3天内
(162条评论)
7.6
SShtv

Your task is clear to me and I am ready to solve it. I have successful experience performing similar work. These are screenshots of some of my works. [login to view URL] h 更多

$250 AUD 在3天内
(64条评论)
5.7
TechnoGuruu

Hi, I have checked your project details and file attached. I will create the automated quotation sheet for you where you will have to just select the product codes and rest of the data including pictures will be pic 更多

$250 AUD 在5天内
(52条评论)
5.3
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. looking to hearing from you. Kind regards

$555 AUD 在10天内
(52条评论)
5.3
younus15

I can do your project in less than [4] Days according to your description (If your project need manually data processing) with full delivery and without error. I would also complete your project with the highest precis 更多

$555 AUD 在10天内
(88条评论)
5.6
pm9887

Hi, I am expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for any kind of work, 更多

$277 AUD 在10天内
(39条评论)
5.0
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. I know the VBA code you need to automatically add picture in a cell. You may check some of my projects here: [login to view URL] 更多

$250AUD 在1天里
(57条评论)
5.2
whitehorsetechn

Hello! This is white horse Technologies and I was glad to see that you're looking for help for project Create an excel quoting template, which imports and resizes pictures. I've delivered more than 40 projects in 更多

$250 AUD 在4天内
(13条评论)
5.3
SayTechSolution

Hello there? I have read your project brief and can see you want to create an excel template for quoting based on your requirements. I have over 3 years experience in ecommerce Industry and admin support. I'm much i 更多

$450 AUD 在4天内
(38条评论)
4.8
Diliphero

Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am very proficient in VBA, Macros and Excel dashboards. My business and financial backg 更多

$700 AUD 在10天内
(14条评论)
4.7
ilkecokay

Hello sir, excel expert here. I can help you for low price but i have a question. It isn't completely clear where do you get the data from? Let's say cell A1 in excel is LETV439 as in your file, where do the Le Grand G 更多

$250 AUD 在2天内
(19条评论)
4.3
AmitHasanRaj

Hello, I m Omit. I am highly interested in your project. I can assist you to gather all kind of information about this project. Let's discuss some and start. Thanks.

$250AUD 在1天里
(28条评论)
4.4
sevillajk01

hi! I would love to help you with your project. I very confident that I can deliver this project to you with quality and accuracy output from me. Hope you consider me. thanks

$500 AUD 在10天内
(15条评论)
4.0
BaNgan

Hi, I believe we should rely on Excel VBA scripting to add the image in the file Do you have all the images in the same folder? And as you mentioned all images names are based on the sku? I can implement this for th 更多

$250 AUD 在10天内
(5条评论)
3.6
sysdesigner13

Hello! I have read your requirement. I'm confident in your project and I promise to complete this job on time. I have rich experience with data processing in Excel. I have finished many projects like this. Hope yo 更多

$250 AUD 在3天内
(9条评论)
3.7
graphicaa

Hello, Checking the possibilities, will update my proposal shortly Please send a message to me. We discuss more & decide the action plan. Thanks Sebastian Thanks Sebastian

$555 AUD 在10天内
(4条评论)
3.9
KolyaEnterprises

Hello, my name is Nick. I've been using Excel since it first came on the market Lotus 1-2-3 before that. I have literal decades of experience in creating, modifying, and updating spreadsheets that deliver [login to view URL] 更多

$500 AUD 在2天内
(2条评论)
3.2