Kapalı

Create an excel Macro

We are looking for the development of a locally saveable macro to convert one data set to another.

Background

We run a website through Squarespace and do our logistics through a local start-up called Sendle. To upload batch orders to Sendle we need a csv with the headings shown in the attachment titled 'Sendle Template'. We can export from Squarespace the orders we have received. These are exported in the form of the attachment titled 'Squarespace Export'.

Task

We need a macro created that can be locally saved that will move and rename the data in the 'Squarespace Export' so that it looks like the attachment 'Sendle Import'. This will include moving some data, renaming some columns and populating some columns with data (eg 'sender_name', 'pickup_instructions' etc) as shown in the 'Sendle Import' file.

The number of rows of data for each Squarespace export will change from time to time, so please build a macro that includes 25 rows of autofilled data e.g. as is required in the 'sender_name' and 'pickup_instructions' columns.

Timing

Within 1 week.

Please contact me for more information.

Beceriler: Excel

Daha fazlasını görün: macro excel create word, software write mq4, create macro excel, software write chip epson, useful software write book, software write web specs, macro excel create file, create installer macro excel, software write edid, create internet macro excel, software write websites idea, create print macro excel, excel create html macro, software write book images, software write books, software write protection, free software write book, software write book, software write technical manual

İşveren Hakkında:
( 0 değerlendirme ) Australia

Proje NO: #14823236

52 freelancer bu iş için ortalamada 118$ teklif veriyor

jaylancer43

Hello, My name is Jay and I am Expert Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st Daha fazlası

in 3 gün içinde210$ AUD
(477 Değerlendirme)
8.0
cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel vba, formulas Daha fazlası

1 gün içinde 60$ AUD
(495 Değerlendirme)
7.5
in 3 gün içinde250$ AUD
(162 Değerlendirme)
7.1
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

in 3 gün içinde200$ AUD
(178 Değerlendirme)
6.7
aarifakhtar

Hi: I can develop a macro for this. I have a few questions: 1) Is the content of columns A-H fixed? What is the mapping of column I and BA from "Sendle Import" file? Relevant Skills and Experience Please note that Daha fazlası

1 gün içinde 60$ AUD
(138 Değerlendirme)
6.8
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Daha fazlası

in 3 gün içinde180$ AUD
(177 Değerlendirme)
6.9
bouslimi1979

Dear, I ll code a macro where you will select your input file, and the code will do the matching columns and data transformation and provide the outputfile as per the template you sent. Ready to start Relevant Skills Daha fazlası

in 3 gün içinde90$ AUD
(141 Değerlendirme)
6.9
koolsidz

I can help you with this :) Relevant Skills and Experience My Credentials: 20+ of VB Experience. http://www.siddharthrout.com/aboutme/ https://stackoverflow.com/users/1140579/siddharth-rout Please see my reviews. I Daha fazlası

in 3 gün içinde66$ AUD
(147 Değerlendirme)
6.4
dpune

Create macro to convert one data set to another Relevant Skills and Experience Excel/VBA Proposed Milestones $150 AUD - Completed macro Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my fe Daha fazlası

in 7 gün içinde150$ AUD
(110 Değerlendirme)
6.2
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA code Daha fazlası

in 3 gün içinde150$ AUD
(106 Değerlendirme)
6.3
avinav606lx

Hey Mate, I can do this quickly. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the r Daha fazlası

1 gün içinde 94$ AUD
(123 Değerlendirme)
6.2
chriskerpini

Write a VBA macro to read the SquarespaceExport.csv file and reorganize it according to SendlwTemplate.csv layout. Relevant Skills and Experience I have 16+ years experience working with Excel/VBA and 13 years teac Daha fazlası

in 10 gün içinde90$ AUD
(55 Değerlendirme)
6.3
ksriniravi

I can develop a macro with configurability -to address future format changes,if new columns are added / deleted, you can simply specify them in a configuration table, no dependency on Excel specialist. If awarded, I ca Daha fazlası

1 gün içinde 60$ AUD
(79 Değerlendirme)
5.9
dgled

I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced form Daha fazlası

in 3 gün içinde250$ AUD
(30 Değerlendirme)
5.6
nagybatonyi

My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and Daha fazlası

1 gün içinde 94$ AUD
(61 Değerlendirme)
5.7
AlexandrUKR

please clarify details

in 7 gün içinde247$ AUD
(9 Değerlendirme)
4.8
Vasilchenko

Hello I got the idea. I can do this macro. Let's discuss details. Relevant Skills and Experience Excel, VBA Proposed Milestones $135 AUD - Milestone My question is where can I take information to fill empty fields?

in 2 gün içinde135$ AUD
(40 Değerlendirme)
5.0
SShtv

Your task is clear to me and I am ready to execute the project for the 75 AUD. Relevant Skills and Experience I have a lot of practical experience in Excel. Including data conversion. Proposed Milestones $75 AUD - da Daha fazlası

1 gün içinde 75$ AUD
(20 Değerlendirme)
4.3
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Daha fazlası

1 gün içinde 30$ AUD
(28 Değerlendirme)
4.4
nevo1234

hi, i have done similar projects in the past, lets discuss the details. Relevant Skills and Experience I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VB Daha fazlası

in 3 gün içinde100$ AUD
(11 Değerlendirme)
4.0