Create Hyperlink To Worksheet Based On Cell Value

Morning All,

I currently have a list of over 200 customers in a worksheet (Column A).

I also have a unique worksheet for each customer (thanks to a Macro)

Is there a way of automatically hyperlink-ing each cell to the relevant worksheet??

Many Thanks
Ross

Hi pls try this and see.
If you have all customers starting from A1 to 200, put this formula in B1 and drag till B 200

Please Login or Register  to view this content.

or you can give this a try..
=HYPERLINK(CONCATENATE("#","'",A1,"'","!A1"),"Click Here")