Find Jobs
Hire Freelancers

excel markro for onlineshop to label printer

€8-30 EUR

Closed
Posted about 6 years ago

€8-30 EUR

Paid on delivery
We have a Exel file from a Online Shop and we would to search for Items and Adresses and put them on a file to print it out whit an Labelprinter . How should it operate. First we have a excel sheet with 3 Pages (Data In , Translation, Print) #Data here we but the Shipping Excel file from the online Shop inside. We also need there a button "start" for starting the makro. Okay after we have insert the Date we have to copy some Fields it to the Sheet print. So we have to copy Field Q, R,S,T,WVU from “Data In” and put it on Sheet "Print" . But first we have to Create in the sheet "print" a Label. In this we put the Information. (Label is width : 15.2cm x high 10.6cm ) Okay after that we copy the buyed item and the number of pieces to etiquette. But there we have to check whether the Customer had more orders. (1 etiquette/Label per Order) And we have to Translate the sku (Field “H” in Data In). We only take the Translation from Sheet #Translation : There are 2 Field (SKU , Name) So we compare the SKU with the translation and but only the Field “Name” on the Etiquette in Sheet “Print”. We also have to put the number of pieces in the same Etiquette. If there are more orders we have to print them among themselves. If there are no Translation we put the SKU on the Sheet print -> on the Etiquette. The Marko shoul do it vor all Transaktions in the sheet “data In” That`s all  Attention on the Sheet “print” we have to persist on the Label size.
Project ID: 16550657

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average €26 EUR for this job
User Avatar
Hi there! I have already gone through the project's description and I'm sure that I can help you with this. I have an excellent experience working with advanced Excel, using formulas and Macros using VBA, Let's see how I can help you
€30 EUR in 0 day
4.9 (38 reviews)
5.2
5.2
User Avatar
Hello, You might be wasting you money and time with excel sheets. You need a web application to do all the work by itself. Let me explain over chat. Thanks
€34 EUR in 1 day
5.0 (8 reviews)
4.2
4.2
User Avatar
Hi, I think I can do your job. I did some similar macro VBA projects here. I'd be glad if you want to take your time to see my review in my profile page then you can decide. I'm waiting for your answer. Thank you
€19 EUR in 2 days
5.0 (37 reviews)
4.4
4.4
User Avatar
Hello, I am an expert in Excel and Macros having more than 5 years of experience, Please consider me for the job. Looking forward to hear from you soon.
€23 EUR in 1 day
4.7 (11 reviews)
3.9
3.9
User Avatar
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
€25 EUR in 2 days
5.0 (6 reviews)
2.4
2.4
User Avatar
Hey! I have got experties in data entry please consider have a good day . Thanks!
€12 EUR in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hi, I just came across your job advert and would like to help you. I am a very experienced VBA programmer. I guarantee 100 % satisfaction within a short amount of time. Even though my bid is much higher than of other freelancers, I deliver top work and I am an honest persons, not like many others offering the cheapest options. :) Please contact me to discuss details. Philipp
€100 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am deeply interested in this project .I can do all the functional needs with a mastery .
€30 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€8 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good at Data Entry will ensure prompt delivery when hired
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I've written several Excel macros before, I think your requirements are doable within the required period.
€11 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Accuracy with time management. Relevant Skills and Experience Excel, Ms Word, Data processing, typing.
€17 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am applying for the position for your excel sheet Relevant Skills and Experience I have experience in excel sheet and Google spreadsheet
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a large experience in excel for 4 years cause of my job as data processing ana management specialist
€12 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€24 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi I am akram, I am new here but I have previous experienced in data entry, if you give me a chance I think I will do my best one thing more I will delivery your work within 7 days, Relevant Skills and Experience I am skills in ms office, excel, power point, Auto Cad, I am very aactive person I want to do hard work for my client,you can provide me your task I will handover in a specific time,
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRIA
GRaz, Austria
5.0
3
Payment method verified
Member since Jan 23, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.