Find Jobs
Hire Freelancers

Macro to convert an excel single cell (delimited values) format and create child rows of all variations

$30-250 USD

완료함
게시됨 약 6년 전

$30-250 USD

제출할때 지불됩니다
In the accompanying example file “BEFORE- original source data x3 product [login to view URL]”, Column B cells entitled ‘finishoptions’ contain the Attributes data in a delimited string. This data needs to be rearranged into a new format. The data in the single cell (e.g B2, B3 etc) is currently one string of option values paired with section titles. These section titles need to be converted to individual column titles and the accompanying Attribute values need to be assigned to the relevant column and to create rows of individual Children of that product. For each and every combination of finished Attributes for that original parent row we need a new child row variant. Please see the example file “AFTER- macro example final output for [login to view URL]” to visually explain the intended result. Full brief in the attached Word doc.
프로젝트 ID: 16901435

프로젝트 정보

11 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi, my name is Selim. I can deliver the output on sunday. I read your "Macro to convert an excel single cell (delimited values) format and create child rows of all variations" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$200 USD 3일에
4.9 (289 건의 리뷰)
7.8
7.8
11 이 프로젝트에 프리랜서들의 평균 입찰은 $113 USD입니다.
사용자 아바타
HI, I am good at Excel and vba. I have referred the files attached Before and After. I can create variations, based on the requirements. Looking forward to discuss further in the chat. -Chandra
$100 USD 0일에
5.0 (875 건의 리뷰)
8.0
8.0
사용자 아바타
Hi, I ll code a vba macro where you will select the input file (what you call before) and click a button to generate the output file where we will find a row per each combination. Thanks
$100 USD 2일에
4.9 (291 건의 리뷰)
7.7
7.7
사용자 아바타
This is using for upload to ebay ? I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$100 USD 2일에
4.9 (122 건의 리뷰)
7.0
7.0
사용자 아바타
Hi, i m serious freelancer with 100% completion rate and i've completed hundreds of automation projects like this one without having a single problem. I went through attach description in Word and yes this definitely can be automated. If you are interested, please message me, and i will tell you step by step how i plan to process this and generate desired output. Thanks, Milan
$133 USD 1일에
5.0 (501 건의 리뷰)
7.0
7.0
사용자 아바타
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$144 USD 3일에
4.8 (263 건의 리뷰)
7.1
7.1
사용자 아바타
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
$60 USD 0일에
5.0 (107 건의 리뷰)
6.2
6.2
사용자 아바타
Hello, I have some experience with your work. I usually can catch on to a new job fast as long as the instructions are clear. I can use Excel and research on the internet.
$155 USD 3일에
2.0 (2 건의 리뷰)
0.8
0.8

고객에 대한 정보

국기 (UNITED KINGDOM)
Knutsford, United Kingdom
5.0
1
결제 수단 확인
4월 24, 2018부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.