GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Microsoft Excel function formula

   Click here to post similar project

Microsoft Excel function formula is project number 159446 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider hiratariq
Budget: $30-100
Created: 07/15/2007 at 16:00 EDT
Bidding Ends: 07/17/2007 at 16:00 EDT
Project Creator: xocarl View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(5 reviews)
Description: Setup Excel function to reference a value on another sheet by using an existing column value. It would take that refrenced value and post beside it in next column.

Example

You have following values on multiple sheets:

Sheet one
Col C Col D
ARZ blank
TB blank
ATL blank

Function would recognize all ARZ, TB, etc. on all sheets – then, to the column just to the right, reference a single sheet that holds a value as such:

Sheet 14
Col A Col B
ARZ 3
TB 17
ATL 6

End result: I can enter values (a single or 2 digit number) to sheet 14, column B. It would relate directly to column A. Then, every Col C on every other sheet would post Col B value (from sheet 14) to the column to the right of it on its respective sheet.

Sheet one
Col C Col D
ARZ 3
TB 17
ATL 6

I would send you Excel file, you would program this function then send it back to me.
File is attached.
Use PMB for comments or questions. I need this the quicker the better.

Additional files submitted:
Mag2007.xls
Report violation
Job Type:
Database: Other
Operating system: (None)
Bid count: 2
Average bid: $ 50

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
hiratariq
View PM Post PM
$ 50 1 day 07-15-2007 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(14 reviews)
Hi! Please see PM.
Richardson183
View PM Post PM
$ 50 2 days 07-15-2007 (No Feedback Yet)
I can do this. I can make Excel Macros in no time. Payment via Paypal Upon Completion.
Bid on This Project

 

[ Freelance ] [ Web Forms ] [ Join GAF Free ] [ View All Projects ]

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

We have thousands of satisfied clients around the world. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier. A freelancer is an independent worker, not on salary, hired instead on a project basis. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. Our mission is to find the best possible freelance workers at the best possible price.

Companies of any size have used our web services. We provide a safe escrow environment and you don't release the money until project is completed. If you never tried to contract work to another part of the world you have your chance today. Sign up free! Buy services with help from our secure escrow system.

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