A
Andy Roberts
Hi
I have a spreadsheet with each job we do in Column A and Job Name in Column
B and postcode in Column C e.g. 9999 Smith Road, London SW19 6RE.
Here is what I'm looking to do...
Have a command button at the top of the sheet which when pressed prompts for
a Job No. I would enter the job number and it would create a folder in a
specific network drive with the title "9999 - Smith Road, London SW19 6RE"
In addition it would hyperlink the Job number to the folder it has just
created.
Also some address have "/" characters in the Job Name cell which can't be in
folder/file names so it would need to replace these with say a "," in the
folder name.
Also it would need to check for any folder with the same job number at the
start
Andy
Office 2010
Win XP Pro SP3
I have a spreadsheet with each job we do in Column A and Job Name in Column
B and postcode in Column C e.g. 9999 Smith Road, London SW19 6RE.
Here is what I'm looking to do...
Have a command button at the top of the sheet which when pressed prompts for
a Job No. I would enter the job number and it would create a folder in a
specific network drive with the title "9999 - Smith Road, London SW19 6RE"
In addition it would hyperlink the Job number to the folder it has just
created.
Also some address have "/" characters in the Job Name cell which can't be in
folder/file names so it would need to replace these with say a "," in the
folder name.
Also it would need to check for any folder with the same job number at the
start
Andy
Office 2010
Win XP Pro SP3