Hi
I have looked about but can’t see anything quite like what I need.
I apologize if there is.
I need to create a automatic hyperlink based on the value of two cells.

Example:

A1= SMITH A2= ORDERNUMBER A3= HYPERLINK

The hyperlink in A3 will be MoreInfo\ORDERS\SMITH\922908

CELL A1 IS THE CUSTOMER NAME AND A2 IS THE ORDER NUMBER, THESE WOULD CHANGE FROM LINE TO LINE

I CREATE THESE FOLDERS IN A SHARED DRIVE (MoreInfo\ORDERS\??\922??
BEFORE I ENTER THE INFO ON THE SPREADSHEET.
So I JUST NEED THE LINK TO APPEAR IN A3 AS SOON AS I FILL IN THE CUSTOMER AND ORDER IN A1 AND A2

I hope this makes sense, I hope someone can help as I am tearing my hair out here.
Thanks in advance
Kevin

Why not take care of this with a formula?
Place this formula in cell C1:
=HYPERLINK("MoreInfo\ORDERS\" & A1 & "\" & B1)

You can populate it down as far as you wish to go. If you want Excel to automatically place this formula when a1 and b1 are entered you can add a line to Worksheet_Change and/or Worksheet_Calculate to set the formula of column C to this when columns A and B aren't empty.

Hoped this helps solve your problem.