In Progress

Excel Macro needed: Comparing and rewriting cells in different tables

Hello Folks, i have to solve the following issue:

There are ten Excel Sheets which are sent from different destinations from time to time. I call them "Compare-Tables"

And there is one Excel Doc which is an export from a online shop.

I call this File "Export-Table".

In the Export file there is one Column with Codes.

AI, red background and in the tables you'll find Codes and Names of cities which belong to one data set / row.

The task is to write a macro which automatically compares the Codes of the Export-Table with the Codes of the Compare-Tables and read out the City for each Code. Finally the City for each Code should be written in the field CN "Bestell17", coloured yellow.

The Macro must do that automatically for all of the eleven Tables.

Each Code is different.

You got it? Budget is about $ 50-60

If you can do that, please make your offers soon.

We need a 100 percent working macro on Monday.

Thanks!

Skills: Excel, Visual Basic, Windows Desktop

See more: comparing tables macro, excel macro compare tables, we excel, solve codes online, in sent, excel &, macro comparing cells, macro comparing cells excel, camparing cells macro, 2008 macro rewrite code, marco compare tables, macro comparing rows excel, excel macro time difference, rewrite excel macro, compare rows macro columns, excel macro rewrite cells, compare tables net access sql, find table macro excel, excel macro compare rows, excel macro needed, excel comparing time, excel macro comparing cells, excel macro compare table, compare tables using excel macro, excel macros comparing

About the Employer:
( 25 reviews ) Berlin, Germany

Project ID: #242874

Awarded to:

SergeyPlus

Hello. Look PM please. Sergey S.

$30 USD in 1 day
(13 Reviews)
4.5

6 freelancers are bidding on average $37 for this job

gvyshnya

I will be pleased to apply my 12+ year experience to authoring your macro. Please see details in PM

$50 USD in 2 days
(10 Reviews)
4.2
tindz99

i can do that.

$50 USD in 2 days
(3 Reviews)
2.2
IlyaAkaBB

I can do it for 3-4 hours. Hope to work with you Check your PM

$30 USD in 0 days
(0 Reviews)
0.0
macrodoctor

This is really easy. Done it lots of times.

$30 USD in 0 days
(0 Reviews)
0.0
nayagamvalli

Hi i can do this for you in 2-3 hours. I have written so many macros like this.

$30 USD in 0 days
(0 Reviews)
0.0