Hi i'm a newbie when it comes to macros so hopefully someone can help me.
I'm trying to create a macro that asks (a dialog prompt) an operator to enter information into a new row, then creating a
hyperlink to another workbook but saving the second workbook as a name that has been entered.
E.G. the operator has been prompted to fill in 'A21' they put in 'Newbie' and the macro creates the second hyperlinked
workbook as 'Newbie'

Hope that explains it
Many Thanks
Aaron