GetAFreelancer.com - Excel Macro needed: Comparing and rewriting cells in different tables

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 GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider SergeyPlus)

Status: Closed

Budget: $30-250

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

Bidding Ends: 04/02/2008 at 6:24 EDT

Project Creator: bzmedia
Buyer Rating:
(4 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

Job Type:

Excel
Visual Basic
Windows

Database: (None)

Operating system: MS Windows

Bid count: 6

Average bid: $ 37

Related project

3 widgets / gadgets for small jobsite ^Featured

posted by jeronimobo
Budget: N/A

Messages Posted: 0

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

Service Providers

PMB

Bid

Delivery Within

Time of Bid

Provider Rating

SergeyPlus

$ 30

1 day

03-28-2008 08:13

(13 reviews)

Hello. Look PM please. Sergey S.

tindz99

$ 50

2 days

03-28-2008 06:56

(7 reviews)

i can do that.

gvyshnya

$ 50

2 days

03-28-2008 11:13

(4 reviews)

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

IlyaAkaBB

$ 30

0 days

03-28-2008 08:17

(No Feedback Yet)

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

macrodoctor

$ 30

0 days

03-28-2008 09:29

(No Feedback Yet)

This is really easy. Done it lots of times.

nayagamvalli

$ 30

0 days

03-28-2008 10:23

(No Feedback Yet)

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

[ Secure Forms ] [ Website Design ] [ Web Development ]

What is GetAFreelancer.com? ( Read about the company )

We have thousands of satisfied clients around the world. Our mission is to find the best possible freelance workers at the best possible price. We provide a safe escrow environment and you don't release the money until project is completed. Our escrow feature is developed to protect both buyers and sellers. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! GetAFreelancer.com is one of the largest sites of its kind. We have earned a good reputation and you can trust us.

Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world. It's easy, fun and very affordable to outsource your project with our site. A freelancer is an independent worker, not on salary, hired instead on a project basis. If you never tried to contract work to another part of the world you have your chance today. Sign up free! Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.