Data finding and an associated data range posting elsewhere in the same worksheet

Task 1

These two teams here are a forthcoming fixture, I´d like to search the range (Range A78:L2000) to find every time they have played each other and then in the columns R to V enter the data for each previous meeting of


home team

home team score

away team score

Away team.

Note I require all instances for

Ravenna v Valentia and

Valentia v Ravenna

Task 2

In Range W4:Y6 I require the last three times that Ravenna have played at home (Range A78:L2000) , all i require is the same row data from Col L "Std Dev" and the Data from Col N.

In Range W7:Y9 I require the last three time that Ravenna have played away from home, again all i require is the data from Col L "Std dev" and the Data from Col M.

I would like the above repeating for Valentia in the ranges W10:Y12 and W13:Y15.

Please not that the Range A78:L2000 is in date order, oldest first and that the data I require will be at the bottom of the range (some of which is unpopulated at the moment but won´t always be)

Taidot: Excel, Visual Basic for Apps

Näytä lisää: data range, 2013 visual basic applications excel, time range, excel find date, excel 2013 visual basic applications, excel 2013 visual basic, visual basic applications 2013, visual basic applications excel 2013, order posting, last moment score, time worksheet excel, range, applications require, visual basic excel find, excel visual date, team fixture excel, excel range find, visual basic applications excel, excel fixture, move data acess sql data conversion vbnet

Tietoa työnantajasta:
( 8 arvostelua ) Los Barrios, United Kingdom

Projektin tunnus: #4201079

Myönnetty käyttäjälle:


Hi Neil, I have got the requirement. Please check your PM. Thanks

$15 USD / tunti
(4 Arvostelua)

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


I know how daunting it is to try and describe what you are wanting. I have been doing my contracting work with VWorker/Freelancer for the past 3 years, I had completed 70 projects ranging from Excel VBA to SQL Server Lisää

$20 USD / tunti
(36 arvostelua)

Very well understood. Sample records done. Please view my PMB for sample file and more details.

$15 USD / tunti
(27 arvostelua)

Having a team of Professionals. We provide high quality work with accuracy.

$20 USD / tunti
(31 arvostelua)

Hi, the project it's already done. Please refer PM, for the FULL FILE and details. Regards, DMD.

$25 USD / tunti
(13 arvostelua)

Hi Sir! **Your file IS FINISHED!!!** See PM. Highly experienced in Excel macros, formulas and gambling! Please Check my credentials. Let me help. Thanks in advance!

$15 USD / tunti
(11 arvostelua)

I can do this for you. Please Check PMB for details.

$20 USD / tunti
(10 arvostelua)

Hello sir, I can do this project. Kindly check your PMB for my resume. Thanks

$15 USD / tunti
(3 arvostelua)

Hi, Your macro is ready. Please see PMB. Best, Sandeep

$20 USD / tunti
(1 arvostelu)

Hi, I can do this. It is easy for me. Please contact with me to start just now. Thanks.

$20 USD / tunti
(0 arvostelua)

Ready For it

$17 USD / tunti
(0 arvostelua)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Lisää

$25 USD / tunti
(0 arvostelua)