use vba to find simular names and copy values into cells

**AnthonyMoody** · 09-25-2011, 10:22 AM

Hey!

I just started with vba and now I want a little help to find a good way to solve my problem

I have made a sheet where you can see what I want help with.

: I want a macro to automatic take the change from sheet "games" (the change are in cell I2 and J2) copy it into the table on sheet "table". The macro is suppose to find the right place automaticly. It should search after the Team names from sheet "games" and search in sheet "Table". Find the next open cell (YELLOW IN TABLE) and copy the value in!

Hope you understand the problem! If you just can help my with the Home team macro I suppose I can make it work.

Thanks in advance! :D
Anthony Moody

**watersev** · 09-25-2011, 11:14 AM

hi, AnthonyMoody, please check attachment, run code "test"

**Marcol** · 09-25-2011, 11:37 AM

This is not possible with the Sheet "Games" as you have it, there are to many linked formulae, if we try to use it the values change as we go. So the calculations will have to be done separately in VBa.

First we have to have some rules clarified.
If you look at Sheet "Games" I have modifeid your formula anchors and created 3 scenarios, you will see that one returns FALSE, what should it be?

Forget the VBa in this workbook, it's just a starter that revealed this problem.

**AnthonyMoody** · 09-25-2011, 12:01 PM

thanks a lot for the respons

watersev solved the problem thanks a lot :D
You are awsome!

**watersev** · 09-25-2011, 12:03 PM

@AnthonyMoody, please redownload file, the code has been modified, new file: EXCEL%20SAMPLE(11).xls

**Marcol** · 09-25-2011, 12:09 PM

So you have no intention to include other games in your worksheets ...

I agree that watersevs' solution works, but only for one game.
What happens when you enter the weeks' results?
How is the error I pointed out handled?