Project Detail

VBA for Excel/Find record from the list  

VBA for Excel/Find record from the list is project number 455080
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: tusharvv

Budget: $30-250

Created: 06/21/2009 at 2:40 EDT

Bid Count: 18

Average Bid:
$ 32

06/28/2009 at 2:40 EDT

Project Creator: Tandem7
Employer Rating: 9.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/10 (51 reviews)

Bid On This Project
 

Description

Hi all,
This is an easy task. Do not bid more than minimum.
TASK DESCRIPTION
1. Create a button in Sheet2 of SourceFile.xls. At the beginning, Sheet2 has one column with data (A)
2. For each line column A in Sheet 2, find all the records (lines) that the value in column B in Sheet1 of SourceFile.xls is the same as column A in Sheet2
3. Copy all found records (lines) and make a new file ResultFile.xls that the content (columns) is the same as SourceFile.xls
4. In Sheet2, write the “found values” in column B and “not found” for value that cannot be found in column B of Sheet1

Thanks


Additional information submitted:

06/21/2009 at 6:03 EDT:
Hi all,
I forgot a preparation step that wee need to collect all data from all other files (example: Source1, source2,...anothersource3...)into one SourceFile.xls. Therefore, we will need another button to collect data first. This button will work:
For each file in folder1, copy all data and paste into the next line of SourceFile.xls and delete that file.
Finally, we will have only one SourceFile.xls and proceed the Finding tasks.
Thanks


Additional files submitted:
FindDataUsingVBA.zip

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

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

 

30

1 day

06-21-2009 04:13 EDT

Dear Tandem7! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

help

 

30

0 days

06-21-2009 03:33 EDT

We can do it. Thank you

help

 

30

1 day

06-21-2009 04:42 EDT

Hi - Please check PM for details.

help

 

30

0 days

06-21-2009 05:49 EDT

Hello - My bid is for an Excel VBA macro. Thank you. Chandra Ram

help

 

30

0 days

06-21-2009 06:18 EDT

This can be done using VBA. I am ready to start immediately. Please refer to PM. The project will be completed in 6 hours.

help

 

30

1 day

06-21-2009 05:56 EDT

Hello, Can finish the job within next 24 Hrs

help

 

30

1 day

06-21-2009 06:03 EDT

Exceptional quality & Fast work. *** CAN BE COMPLETED IN 6 HOURS ***. Please refer to Profile & PMB for details. Thanks FAZ

help

 

30

1 day

06-21-2009 04:21 EDT

Hi I just finished a similar assignment. All you need is "findnext" to exhaust repeat items.

help

 

30

0 days

06-21-2009 05:03 EDT

Hi, Check PM. Thanks, Sumeet.

help

 

30

2 days

06-21-2009 03:02 EDT

Dear Sir . Can be done as you wish. Thank you, Ioan

help

 

30

4 days

06-21-2009 03:44 EDT

Yes, it is an easy task. It can be done with macros and few functions in visual basic. I am always working with excel and macros. So If you want to see any similiar work I have done in excel please send a PM

help

 

30

1 day

06-21-2009 05:11 EDT

Hi VBA is the best solution, to find anything in Excel and do what you imagine with that record. B.R. Zoltan

help

 

50

0 days

06-21-2009 06:51 EDT

Hi, I have fully read your requirement and understood them. I will be more happy to work for you. Thanks djain01

help

 

30

2 days

06-21-2009 03:02 EDT

(No Feedback Yet)

We can deliver this for you with no issues. You will find no issues for getting this delivered as per your description in the description section.

help

 

30

5 days

06-21-2009 04:22 EDT

(No Feedback Yet)

ya,Its very easy. We have other projects about stock market,so no of days for completion is 5,otherwise we can do it in 1 day.

help

 

30

0 days

06-21-2009 05:10 EDT

(No Feedback Yet)

Hi! It's realy easy task. I work with VBA everyday and do the same task. So, contact me for details.

help

 

40

1 day

06-21-2009 05:43 EDT

(No Feedback Yet)

we have already developed this kind of application

help

 

30

0 days

06-21-2009 06:49 EDT

(No Feedback Yet)

Hello sir, I am a graduate from IIT(Indian Institute of Technology, The best Technology Institutes in India), and am working with a global firm which delivers IT services to a vast number of clients across the world. I have very strong programming skills in VBA and Excel and IITians are best known for mathcmatical skills and programming techniques. This task can be done very easily.

help


    Bid on this Project