My need is this; I have a master spreadsheet with Column A being a list of
9 character control numbers which are text entries for hyperlinks to another
folder filled with Excel spreadsheets, whose first nine characters are the
control numbers matched in the master Spreadsheet. What I would like is an
update spreadsheet button; not a new toolbar button, on the master
spreadsheet that will tell excel to go look in a specified folder, it will
always be the same folder, check to see if there are any files in the folder
which are not on the master spreadsheet already. If there are new files
create a new hyperlink; titled with the first nine characters of the file
name in the next available cell in Coloumn A. When it is done updating a
little window saying how many entries were created or if none were created
would be nice, but not neccessary.
I am not a VB programmer by anymeans and my Excel formula skills are
moderate, so any help with this would be greatly appreciated, thank you.