thomasbeard
Board Regular
- Joined
- Oct 19, 2005
- Messages
- 139
In Sheet1 I have a list of names next to a list of worksheet names to which they need to be allocated to. What I want to know is how I allocate these names to the correct sheet.
For example if Sheet1 tells me:
Tom Sheet2
**** Sheet3
Harry Sheet2
Pete Sheet 3
When I go to Sheet2, I would like to see:
Tom
Harry
and Sheet3 will show:
****
Pete
Any ideas?
Thanks
For example if Sheet1 tells me:
Tom Sheet2
**** Sheet3
Harry Sheet2
Pete Sheet 3
When I go to Sheet2, I would like to see:
Tom
Harry
and Sheet3 will show:
****
Pete
Any ideas?
Thanks