Find Jobs
Hire Freelancers

Excel VBA automate data to copy data from columns

$10-30 USD

Completed
Posted over 4 years ago

$10-30 USD

Paid on delivery
PLEASE NOTE: THE DATA IN EXCELL SHEET IS RAW DATA THAT SERVES AS AN EXAMPLE. THE IDEA IS TO FILL THE COLUMNS FROM SCRATCH AND CLICK IN ONE BUTTON TO HAVE THE RESULT IN THE SAME SHEET OR IN OTHER IN THE SAME BOOK Description: Compare data in all rows for Column "A" and all rows fro Column "D" If theres the same data in a row in Column "A" and Column "D", the data in Column "B" and Column "C" should be written in Column "F" and Column "D", in front of the duplicated value founded. Example: 1- The system should be able to find duplicated data in Column "A" and "D" The "8433281003248" is in A2 but also in D97. So, in F97 and G97 should be put copied the data from B2 and C2. Whe will have the line D97 whith "NUMBER B"; "DESCRIPTION" other 2 columns copied: "PRICE" and "STOCK" ANOTHER EXAMPLE: When reading column A, the system detects in A12 the value "4960999577470". When reading the column D, the system also found this value in the D3. So, in column F3 and G3 should be copied the B12 nd C12 values.
Project ID: 22731236

About the project

38 proposals
Remote project
Active 4 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
I understand your requirement. You will have a nice one click button. After clicking it, the macro will loop all cels in source columns and fill target columns with processed data. I will start coding instantly and provide perfectly working file today. 13 years excellence in office automation and business application development. Responsible for what i deliver! Payment only after 100% satisfaction.
$15 USD in 1 day
5.0 (20 reviews)
4.0
4.0
38 freelancers are bidding on average $30 USD for this job
User Avatar
Hello! I can compare your columns. I will do it with VBA, it's easy for me. I can finish in 1 day. You will not be dissapointed, I have a big 31% rehire rate. Thank you!
$25 USD in 1 day
5.0 (363 reviews)
8.0
8.0
User Avatar
Hello, I’m an Excel VBA expert and I would like to help you with this very simple project. Please check my profile and contact me to discuss further details. Regards.
$25 USD in 1 day
4.9 (477 reviews)
8.0
8.0
User Avatar
Hi, I have understand the project requirement & interested to make macro for this project. I will start right now and make it within 1 hour. Please send a message so we can discuss more & start the project. Thanks.
$15 USD in 1 day
5.0 (301 reviews)
7.1
7.1
User Avatar
Dear client I understand the scope of work involved in the project. I can automate the task for you and can provide the code for future use as well. Please contact me. Roy
$30 USD in 1 day
4.9 (456 reviews)
7.3
7.3
User Avatar
***I ensure you 100% accuracy and fast delivery** Hi there, I have read your description and so clear instruction and easy to understand. If you want I can start right now. I am online now and eagerly waiting for your response. Kind Regards, Amran
$25 USD in 1 day
5.0 (131 reviews)
7.0
7.0
User Avatar
Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$25 USD in 2 days
4.9 (149 reviews)
6.6
6.6
User Avatar
$ 13 Only ----- In just 2 hours ------ Excel VBA Macro Coding, Formula Generation and Automation Expert ----- I can send you sample project file to show my expertise.
$13 USD in 1 day
5.0 (261 reviews)
6.3
6.3
User Avatar
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer and have done many similar jobs. I have excellent knowledge and experience of manipulation of strings rows and columns. So, can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$30 USD in 1 day
4.8 (119 reviews)
6.0
6.0
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$30 USD in 1 day
4.9 (112 reviews)
5.9
5.9
User Avatar
Hello sir, Please take a look at my reviews and portfolio. I am interested in your project as well. I would like to discuss the details via pm. I look forward to hearing from you soon. Best Regards,
$50 USD in 1 day
5.0 (32 reviews)
5.5
5.5
User Avatar
Hi I hope all is well with you. I've viewed your Excel task and understood it. I can code it quickly as I've coded several Excel tasks like that. I'll detail in private chat. Best Regards Zurab
$55 USD in 1 day
4.7 (37 reviews)
5.9
5.9
User Avatar
Experienced project professional, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery of dashboards and financial analytics. I currently work remotely and provide part-time support EXCEL GOT-IT PRO, an on-line service to assist students and small business owners with advanced EXCEL challenges in finance and stats. I have reviewed your requirements detail an confident I can provide you with a quality solution.
$21 USD in 3 days
5.0 (38 reviews)
4.9
4.9
User Avatar
Hi There, Expert here, i have read your descriptions, i can provide you quality work on time. Would you please come to the chat box so we can easily discuss about project details. Thank You Regards.
$100 USD in 2 days
5.0 (22 reviews)
5.0
5.0
User Avatar
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$10 USD in 1 day
4.9 (74 reviews)
4.9
4.9
User Avatar
I understand you requests , I can do , please contact.................................................................
$20 USD in 1 day
5.0 (10 reviews)
4.9
4.9
User Avatar
Hi, I can give you the vba macro that will do the task you need to make sure the Number B has the coorect price and stock referencing Number A. Regards. Reuben
$20 USD in 1 day
5.0 (20 reviews)
5.0
5.0
User Avatar
. I am interested in this work and hope to do it As I will do with high quality and in the shortest possible time and at the best price Actually,I have very important reasons make me very interested in this kind of work. This work is my stable source of money. So, I take care of it. Your work will be done professionally, accurately and in time I hope we will work together . N.B : I can make a sample before working
$50 USD in 1 day
5.0 (26 reviews)
4.3
4.3
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
$30 USD in 1 day
4.5 (24 reviews)
4.7
4.7
User Avatar
Hello! Am very interested in ur project and I am an expert in PDF/Power point/Word/Copy typing/Data Entry/Excel/VBA.I can meet all requirement of the project. Please ping me for further discussion.
$10 USD in 1 day
5.0 (24 reviews)
4.4
4.4
User Avatar
Greetings, Hope you are feeling very well. I think here you are looking for someone to get data to copy data from columns .I understand your project description. But I want to know more about your project. So, can we discuss more? I am really confident that, I can do this task very effectively. I'm ready to start now! So, if you hire me then I can be trying to complete this task within your timeline and 100% accurate. Please trust me, I’ll provide you the best quality work. So, please take your time to discuss more on your project with me. Thank you. Read Less
$20 USD in 1 day
5.0 (8 reviews)
1.9
1.9

About the client

Flag of PORTUGAL
Vila Real, Portugal
5.0
36
Payment method verified
Member since Jan 14, 2018

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.