mykal66
10-24-2014, 01:47 AM
Hi everyone - I'm looking for help using named ranges in VBA to populate data in a worksheet if anyone can help please?
I've attached an example of what i am trying to get to work.
Sheet3 literally takes the names of the separate teams on sheet2 to make a named range 'TEAMS'
Sheet2 will contain the separate team info lists and each will have a named range to match their team name e.g. Team1 range A3:B5 is named Team1
On Sheet1 users would use the button and pop up box to select which team information they want to see. The name of the team they have selected shows in cell G4 on sheet 1. This is where i get stuck; i need the code to use the name in G4 and then display the same named range underneaths starting in G5.
As always, help or pointers is appreciated.
Mykal
12433
I've attached an example of what i am trying to get to work.
Sheet3 literally takes the names of the separate teams on sheet2 to make a named range 'TEAMS'
Sheet2 will contain the separate team info lists and each will have a named range to match their team name e.g. Team1 range A3:B5 is named Team1
On Sheet1 users would use the button and pop up box to select which team information they want to see. The name of the team they have selected shows in cell G4 on sheet 1. This is where i get stuck; i need the code to use the name in G4 and then display the same named range underneaths starting in G5.
As always, help or pointers is appreciated.
Mykal
12433