Lengkap

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.

Kemahiran: Pemprosesan Data, Excel

Lihat lagi: 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

Tentang Majikan:
( 1 ulasan ) Brisbane, Australia

ID Projek: #17759216

Dianugerahkan kepada:

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 Lagi

$250 AUD dalam 3 hari
(140 Ulasan)
6.7

48 pekerja bebas membida secara purata $382 untuk pekerjaan ini

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 ( Lagi

$333 AUD dalam 3 hari
(614 Ulasan)
8.3
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 dalam 5 hari
(192 Ulasan)
7.8
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 Lagi

$300 AUD dalam 5 hari
(272 Ulasan)
7.6
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 Lagi

$250 AUD dalam 3 hari
(160 Ulasan)
7.6
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 Lagi

$555 AUD dalam 10 hari
(85 Ulasan)
5.4
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 Lagi

$250 AUD dalam 3 hari
(58 Ulasan)
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, Lagi

$277 AUD dalam 10 hari
(35 Ulasan)
5.0
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 dalam 10 hari
(45 Ulasan)
5.0
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 Lagi

$250 AUD dalam 4 hari
(13 Ulasan)
5.3
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 Lagi

$250 AUD dalam 5 hari
(42 Ulasan)
5.1
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] Lagi

$250 AUD dalam sehari
(35 Ulasan)
5.0
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 Lagi

$450 AUD dalam 4 hari
(37 Ulasan)
4.7
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.

$250 AUD dalam sehari
(24 Ulasan)
4.3
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 Lagi

$700 AUD dalam 10 hari
(12 Ulasan)
4.1
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 dalam 10 hari
(4 Ulasan)
3.9
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 dalam 10 hari
(11 Ulasan)
3.6
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 Lagi

$250 AUD dalam 10 hari
(4 Ulasan)
3.4
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 Lagi

$250 AUD dalam 2 hari
(5 Ulasan)
3.3
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] Lagi

$500 AUD dalam 2 hari
(1 Ulasan)
2.8
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 Lagi

$250 AUD dalam 3 hari
(5 Ulasan)
3.2