Завершено

Excel VBA automate data to copy data from columns

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.

Квалификация: Excel, Visual Basic, Обработка данных, Visual Basic для приложений, Ввод данных

Показать больше updating excel vba workbooks without changing data, excel vba automate excel graphs, excel vba code pull internet data, how to copy data from one excel workbook to another using macro, automate copying of column data from sheet to sheet using excel vba, excel import data from another workbook vba, excel vba copy data from one open workbook to another, excel vba copy data from another workbook without opening, macro to copy data from one sheet to another based on criteria, how to extract data from one sheet to another in excel using vba, excel macro pull data from another workbook, excel vba chart click show data, excel vba create chart display data, vba script copy paste data internet explorer, excel 2003 macros copy web data, excel vba download yahoo financial data, excel vba macro copy columns data, excel vba code download historical data yahoo, excel vba cut paste columns, excel vba automate web query

О работодателе:
( 21 отзыв(-а, -ов) ) Vila Real, Portugal

ID проекта: #22731236

Поручен:

eduuardo

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 pro Больше

$15 USD за 1 день
(12 отзывов(-а))
3.3

40 фрилансеров(-а) в среднем готовы выполнить эту работу за $29

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Больше

$100 USD за 2 дней(-я)
(755 отзывов(-а))
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Больше

$100 USD за 2 дней(-я)
(358 отзывов(-а))
8.0
sergiuloghin

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 за 1 день
(285 отзывов(-а))
7.7
P0L

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 за 1 день
(343 отзывов(-а))
7.4
TonmoyRoy111

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 за 1 день
(359 отзывов(-а))
6.9
amranreza70

***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 Больше

$25 USD за 1 день
(111 отзывов(-а))
6.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

$30 USD за 1 день
(134 отзывов(-а))
6.0
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Больше

$30 USD за 1 день
(87 отзывов(-а))
6.0
zu02

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 за 1 день
(33 отзывов(-а))
5.8
finecodervw

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 informati Больше

$25 USD за 2 дней(-я)
(88 отзывов(-а))
5.7
vsprybhanu

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 Больше

$30 USD за 1 день
(99 отзывов(-а))
5.7
osmanaydin

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 за 1 день
(27 отзывов(-а))
5.2
rashedkhanrubel

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 за 1 день
(74 отзывов(-а))
5.2
Ahmed818

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-r Больше

$10 USD за 1 день
(62 отзывов(-а))
4.6
writingapp

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 Больше

$30 USD за 1 день
(29 отзывов(-а))
4.8
AnowarRatul

$ 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 за 1 день
(58 отзывов(-а))
4.7
umairabdillah12

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 за 2 дней(-я)
(15 отзывов(-а))
4.6
nvbishr

I understand you requests , I can do , please contact.................................................................

$20 USD за 1 день
(8 отзывов(-а))
4.2
jsb1156

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 analytic Больше

$21 USD за 3 дней(-я)
(28 отзывов(-а))
4.3
MonisZafar

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 за 1 день
(8 отзывов(-а))
3.1