Find Jobs
Hire Freelancers

Controls_Answers

$30-250 USD

Completed
Posted over 2 years ago

$30-250 USD

Paid on delivery
Hello, I need a macro that does the following: 1. Searches column “A” of two spreadsheets; (named “sheet-1” and “sheet-2”) for identical matches with cells. 2. When identical matching cells are found in column “A” of both sheets, the cell from “sheet-2”, column “D” is copied and pasted in to the cell on “sheet-1” column “U”. - column “A” of both sheets contain NIST security control numbers, which are alpha-numberic, e.g. MA-4(4).a - “sheet-2”, column “D” contains plain text answers for how a NIST security control is answered - “sheet-1” column “U” is typically empty or has data that needs over written Macros cannot be saved or stored on the network I’m on. We work around that by keeping macros in .txt files and copy/paste them for use within Excel files as needed. Thanks Scotty
Project ID: 31825012

About the project

19 proposals
Remote project
Active 3 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
Awarded to:
User Avatar
Hello, I have seen your requirements, and I am ready to help you create a macro to search for identical matches and copy data from one sheet to another. I am a Data Analyst experienced in managing complex spreadsheets and VBA, and I can quickly and easily deliver the results you need. Please feel free to contact me to discuss your project in detail. Thank you a lot. Best regards, Emilia S
$50 USD in 2 days
5.0 (10 reviews)
3.6
3.6
19 freelancers are bidding on average $116 USD for this job
User Avatar
Hi There, I have reviewed your requirement and I can definitely start immediately. Also I am 100% available during EST (New York Time) hours. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Expert in MS Office/Google GSuite / VBA(Macros)/ GScript /PYTHON/VBA/VB/.NET/WEB/ Access/Excel/Word/Outlook/SOAP/REST/API / SQL Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Charts, formatting, templates, dashboard, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to work with you.. Have a nice day Thank you
$100 USD in 3 days
4.9 (83 reviews)
6.1
6.1
User Avatar
I’m an experienced Digital Marketer with immense love for writing in the field of writing content with my Majors in English and I have written several columns, articles, blogs for different newspapers, magazines, websites etc. I can help in writing well-researched, rich in vocabulary and top-quality articles as per your requirements on the given niche. Also I have mastered tools like Ahrefs, Google Search Console and SEMRush that will help me write content as per SEO standards using relative keywords making your content appear on top of every search engine, giving you an edge over your competitors. Being my client will give you the assurity of flawless and plagiarism-free work in the best possible rates. While writing content I grasp the underlying emotions of the topic, connect with audience, think like an insider, consider the readers' pain points, with the ability to comprehend the context Feel free to hit me up with a message. I'd be more than happy to discuss further details over chat! Kind Regards, Anusha S.
$30 USD in 1 day
5.0 (23 reviews)
5.4
5.4
User Avatar
Hello I am an expert in excel vba macros I read the requirements . And since i made so many macros doing the same function , So , i am ready to finish the work as you need waiting your message Regards
$45 USD in 1 day
5.0 (5 reviews)
2.9
2.9
User Avatar
Hi, I am safdar Ali. I have an outstanding skill in MS EXCEL ,so please give me your assignment. Regards, Safdar Ali
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello i'm shahida zaam I am available and efficient and you can count on me and also I have skills thank you
$145 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir /madam I am a data entry expert more than 5 years. I can do your work with 100% accuracy on the time. thankyou
$180 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm Advanced Excel (MIS), Domestic Data Entry operator Expert. I've experienced of 5 year from MIS Company. I've also got certificate from Indian government. If you give me this project, I will try my best for your satisfaction. Hope you will consider me for this job. My bid amount is negotiable. Lets discuss more details about this project. Thank you!
$90 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I know how to write so will give you knowledge as best of my knowledge for once and while you can opt for this option.
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am passionate about vba excel code, I can just use it to make my office work a lot easier. I'm waiting for you to create the required code. All I need is an example so I can work 100% efficiently. I am waiting for you to contact me. Thanks!
$120 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Honoluu, United States
4.8
1
Payment method verified
Member since Oct 15, 2021

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.