Käynnissä

VBA for Excel/Find record from the list

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 [url removed, login to view] is the same as column A in Sheet2

3. Copy all found records (lines) and make a new file [url removed, login to view] that the content (columns) is the same as [url removed, login to view]

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

Taidot: .NET, SQL, Visual Basic, XML

Näytä lisää: excel vba find record, excel find record, find record excel vba, vba excel find list, vba find record excel, excel find column vba, find vba, vba excel find, vba create list excel, vba with, find record list, vba excel record found, vba excel find record, find record found vba, find record vba excel, show record excel vba, list columns excel vba, records found excel vba, find list vba, vba excel retrieve records, find record excel, excel record list, vba search record, excel record lookup, find records excel vba

About the Employer:
( 60 reviews ) Houston, United States

Projektin tunnus: #455080

Myönnetty käyttäjälle:

refractocd

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

30 $ USD 0 päivässä
(12 arvostelua)
3.9

18 freelanceria on tarjonnut keskimäärin 32 $ tähän työhön

schandraram

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

30 $ USD 0 päivässä
(86 arvostelua)
6.2
djain01

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

50 $ USD 0 päivässä
(71 arvostelua)
5.7
oFAZo

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

30 $ USD 1 päivässä
(15 arvostelua)
4.7
MustafaSR

Hello, Can finish the job within next 24 Hrs

30 $ USD 1 päivässä
(19 arvostelua)
4.3
sphurontek

We can do it. Thank you

30 $ USD 0 päivässä
(2 arvostelua)
3.9
johnsinit

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

30 $ USD 1 päivässä
(8 arvostelua)
3.7
cheungkc

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

30 $ USD 1 päivässä
(6 arvostelua)
3.1
radus28

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

30 $ USD 4 päivässä
(1 arvostelu)
2.9
edatawiz

Hi - Please check PM for details.

30 $ USD 1 päivässä
(3 arvostelua)
2.7
sumeet00

Hi, Check PM. Thanks, Sumeet.

30 $ USD 0 päivässä
(3 arvostelua)
2.6
zszabo

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

30 $ USD 1 päivässä
(1 arvostelu)
1.4
ioanaprof

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

30 $ USD 2 päivässä
(1 arvostelu)
0.5
agacs

we have already developed this kind of application

40 $ USD 1 päivässä
(0 arvostelua)
0.0
leechdraw

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

30 $ USD 0 päivässä
(0 arvostelua)
0.0
yashiscool

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.

30 $ USD 2 päivässä
(0 arvostelua)
0.0
pateluvipul999

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.

30 $ USD 5 päivässä
(0 arvostelua)
0.0
obiwangv

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 Lisää

30 $ USD 0 päivässä
(0 arvostelua)
0.0