Completed

Write a copy and paste macro

1. Start with file name “Macro File” file.

2. Browse to select and open new file, here after referred as source file.

3. Copy text starting in B3 to last cell with text from Sample column from source file to columns SampleID (required) and Magenta ID (required) in the macro file.

4. Copy text starting in S3 to last cell with text from Line column from new file to column LINCD (required) in the macro file.

5. Copy text starting in O3 to last cell with text from SPIRIT Material ID from source file to column MatIDs (required) macro file.

6. Copy text starting in F3 to last cell with text from Pedigree from source file to column PDGRE (required) in source file.

7. The following all apply to the Macro file

a. Populate any blanks cells in column MatIDs (required) from E2 until the last cell with text with “NA”.

b. For all the rows that NA was added in column MatIDs (required), add “Empty” in column LINCD (required).

c. Populate any blanks in LINCD (required) column from C2 until the last cell with text with “NA”.

d. In cell A2 concatenate values in cells, C2,E2, and D2 separated with a double underscore. Apply the same concatenation to the last row with text in column D.

e. Change all the values in A2 to lower case.

Skills: Excel, Visual Basic

See more: visual basic macro copy paste cell, copy paste xls macro, macro copy paste excel applications, excel macro copy paste data application, excel script copy paste cells macro, outlook macro copy paste contacts, copy paste macro excel timed, exel 2003 copy paste macro, write copy paste offline wordpress, clipboard copy paste macro excel, excel excel copy paste macro, paid write copy paste, copy paste macro vba, copy paste product 1 site to another, 1. Sign up and signin with a master control account for everyone added to the account

About the Employer:
( 5 reviews ) Research Triangle Park, United States

Project ID: #24025654

Awarded to:

MimiFL

I went through both files and description and this can definitely be done. And its actually quite simple. I can do this for you today. If you are interested in working with me, feel free to message me. I am available i More

$250 USD in 1 day
(549 Reviews)
7.1

25 freelancers are bidding on average $401 for this job

best4best

Hi, I have gone through the sample Source and Macro files, and understood the project description. I am an Excel expert and ready to create the macro/template to perform the tasks you mentioned. Please take a look a More

$250 USD in 2 days
(146 Reviews)
6.3
VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? More

$250 USD in 1 day
(125 Reviews)
6.4
finecodervw

Hi, Keen to work on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done goo More

$250 USD in 3 days
(89 Reviews)
5.9
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

$697 USD in 7 days
(80 Reviews)
6.3
satishtl

Hi, Went through the project details. - Source File and the Macro file, and the description having to copy certain values from macro file to Soruce file. - Blank columsn with "NA",concatenation with underscores etc. - More

$250 USD in 3 days
(51 Reviews)
6.0
LidijaP

My name is Lydia, I have been working on the computer for the last 15 years. My Top Skills are Excel, Microsoft Office and Internet Research.

$500 USD in 7 days
(14 Reviews)
4.8
ravinderkumar248

Hi there, I am excel VBA expert and can help you in this . I can create Macro for you. Can we discuss?

$250 USD in 2 days
(23 Reviews)
4.6
jaelahoe

Hi there! Will read and work on it right now. As a hiring client, I hated copy-and-paste proposal templates because my requirements were not read. But when I spend time reading the files and properly doing up my pr More

$250 USD in 3 days
(9 Reviews)
3.9
Rumairashraf

Hi there! I am available for your task and do your task with full responsibility and deliver on time. Could we discuss more details over chat? Thank you

$600 USD in 7 days
(10 Reviews)
3.5
solarqw

Hi, I can write an Excel macro to finish your "Copy & Paste" task. I am a programmer good at data handling. I have done many similar projects before. I am ready to work now.

$250 USD in 7 days
(8 Reviews)
2.9
Servicehour24

Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional work More

$300 USD in 5 days
(1 Review)
2.0
cherlykitchenann

Hi Dear Client, I’m an expert in data entry with over 7 years of experience I shifted back to freelance again. And currently, I am working with a self-employed data entry agency as a team leader. I check your job descr More

$260 USD in 5 days
(1 Review)
1.8
ExpertSoul

Hi There, I've reviewed your requirements, I am very interested in your post project. I'm excited with feeling that I would be able to satisfy your requirements in this job. Please leave a message on my chat so we can More

$500 USD in 10 days
(1 Review)
1.2
KECHANKRISNA

Hello, how are you? I'm a Excel, Macro/VBA Expert. I can help you within short time. Please ping me. Best regards.

$250 USD in 1 day
(0 Reviews)
0.0
AISHAHRASHED16

READY TO DELIVER WITHIN 2 DAYS, I can show u sample before we [login to view URL] to start right now . iam a good user of excel .also I am an expert on conversion of PDF to editable Word. I have been working on similar tasks i More

$250 USD in 2 days
(0 Reviews)
0.0
arassolenko

Hi Dear! Thanks for your job posting! I read your job description carefully and I have confidence to do it. I am a C/C++, C#, .NET , ASP.NET, Python(ML) Developer with +6 years experiences and your project is very inte More

$750 USD in 7 days
(0 Reviews)
0.0
Alexader11

After reading your description i feel confident that i can take on the task in a timely manner. Please let me know how i can help thanks.

$500 USD in 7 days
(0 Reviews)
0.0
Pratikjethwa99

Hey there, PLEASE Read my proposal. I can do this task at the lowest fee. as I'm a new freelancer I want to build my profile nicely and I have good knowledge of Microsoft office for doing this task. if you are satisf More

$250 USD in 5 days
(1 Review)
0.0
softman540

hi I would love to work with you on this project, I have an extensive level of experience of 3-yrs as a data entry clerk excel Vba google sheets, web searching virtual assistants and customer service; my experience ali More

$250 USD in 2 days
(0 Reviews)
0.0
shahzaibpro

Benefit of Working with me: I am online 8+ hours for communication with you, so you can check the progress of your project any time you want. I am a skillful and experienced developer, so you will get well structured, More

$500 USD in 7 days
(0 Reviews)
0.0