Refer to another worksheet

**Artarta** · 11-15-2006, 03:20 AM

Hi guys, my first post!!

I have a list of clients that fall under certain categories. I would like to list the categories in one worksheet and list my clients on another. What I would like to do is when I refer to a cetain category (in a certain cell) this will automatically switch to the other worksheet in which my clients are listed.

Many thanks

**VBA Noob** · 11-15-2006, 03:50 AM

Hi,

Sounds like you want a hyperlink

Try this site

http://www.homeandlearn.co.uk/ME/mes11p4.html

If you need values return then your looking at functions like Indirect, vlookup's etc

VBA Noob