Completed

need excel macro urgent work (in 1 day)

I need excel macro done. see the details below (also see excel file for data and sample):-

once the macro is run, the following should happen:-

1) each row with all its data should be duplicated 41 more times. so total there will be 42 rows (including the 1 original row)

for example if there are 100 rows with data, then in the end, there will be 4200 rows

2) the value in 1st original row in column E will be TRUE, the other duplicate data will be empty

3) data in column F: it is in format 1.1 1.2 2.1. 2.2 2.3 2.4 etc

what should happen:-

it should be formated as

[url removed, login to view] in 1st row, then

[url removed, login to view]

for 2nd example as:-

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

4) data in column G will say MERGE for each row in which there is a value for image

5) data in column H will start as 1, 2,3,4 for each row in which there is a value for image

this is very urgent work, i need it done accurately and in 1 day. it needs to be done exactly as i have stated

Skills: Excel, Excel Macros

See more: excel freelance jobs, excel vba freelance jobs, vba freelance hourly rate, excel vba jobs from home, work from home excel projects, part time vba programmer jobs, vba jobs online, excel programming jobs home, I need excel work, need excel macro, work allocation excel macro, schedule vbs script run excel macro specific time day, freelance excel macro work, excel macro work required job work, bid excel macro work

About the Employer:
( 359 reviews ) Victoria, Canada

Project ID: #16467698

Awarded to:

cgullapalli

Hi, I am good at Excel and vba macro. I have referred the requirements. Looking forward to work on the project and discuss in the chat. I can automate the process as stated. -chandra

$35 USD in 0 days
(624 Reviews)
7.7

6 freelancers are bidding on average $65 for this job

$35 USD in 0 days
(53 Reviews)
4.6
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing a More

$45 USD in 1 day
(16 Reviews)
4.3
vaidyag

Hi, I have expertise in excel macros and have executed many projects using excel macros. I may need some clarification on this. This can be easily done. Thanks Regards Vaidy

$61 USD in 1 day
(3 Reviews)
2.7
AbhiAbhishekS

Hello, I'm interested in your project. Please send me a message so that we can discuss more. I have a good knowledge in Excel and data entry.I will accomplish this task in the given budget and time with 100% accuracy. More

$50 USD in 1 day
(2 Reviews)
2.3
khanjzthanjzt

Greetings, We have read the project description and we are experienced professionals in the field of VB, Macros, web scrapping, data mining, data processing, data manipulation and data analysis. Having more than 3 y More

$166 USD in 1 day
(1 Review)
0.0