Project Detail

Excel Macro needed: Comparing and rewriting cells in different tables

Excel Macro needed: Comparing and rewriting cells in different tables is project number 242874
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: SergeyPlus

Budget: $30-250

Created: 03/28/2008 at 6:24 EDT

Bid Count: 6

Average Bid:
$ 37

04/02/2008 at 6:24 EDT

Project Creator: bzmedia
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (5 reviews)

Description

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!

Additional files submitted:
exceldemo.rar

Report Violation

Job Type

See more: background, call, code, data, excel, excel macro, export, file, macro, make, online, online shop, rewriting, task, write

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

2 days

03-28-2008 11:13 EDT

9.8333/10
(18 reviews)

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

SergeyPlus

1 day

03-28-2008 08:13 EDT

9.9375/10
(16 reviews)

Hello. Look PM please. Sergey S.

tindz99

2 days

03-28-2008 06:56 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(11 reviews)

i can do that.

IlyaAkaBB

0 days

03-28-2008 08:17 EDT

(No Feedback Yet)

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

macrodoctor

0 days

03-28-2008 09:29 EDT

(No Feedback Yet)

This is really easy. Done it lots of times.

nayagamvalli

0 days

03-28-2008 10:23 EDT

(No Feedback Yet)

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

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.