Copy from one Worksheet to multiple sheets

[blackmordred]

I know nothin about VBA and have been doing this the hard way and was wondering if there is VBA code to make this easier.

What I trying to do is keep track of hockey scores and then copy to the appropriate team sheet, right now I enter the scores on the schedule worksheet and then I filter it and manually copy and paste to team sheet. So basically I want to run a Macro that will filter first from Visitor column and paste to proper team sheet and then from Home Team and paste to proper team sheet

[Mordred]

Hi blackmordred and welcome to the forum. I am going to look at this but I am disappointed because you don't have the Winnipeg Jets in your workbook .

[Roger Govier]

I know nothin about VBA and have been doing this the hard way and was wondering if there is VBA code to make this easier.

Hi
I know nothing about Hockey, but I think the code on the attached sheet will do what you want.
I filled in a few scores on the sheet which I renamed as Master and ran it and it seemed to do what was required.

Please Login or Register  to view this content.

[blackmordred]

Hey Roger thanks for the help your code comes close, it works with the visitor team but not when it copies the home team, it puts the home team there but not who they were playing against. I will try to work on the code to see if I can get it to work properly.

Mordred unfortunately I used last years stats that's why no Winnipeg but I too am looking forward to this year with the Jets back in the league.

[Roger Govier]

Hi

Sorry about that.
In the last but one line of the copying data, it should be using wsM(cells(i,2). value, not (i,4)

Please Login or Register  to view this content.

[blackmordred]

Thanks Roger that did the trick, very much appreciated