SBrooky
09-13-2012, 04:22 AM
I have a spreadsheet which when clicking a button prompts you to select a folder. It then lists all the folder within that folder in column AA (5 onwards)
Each one of these folders contain a file called 'Monthly engagement measure.xlsm'.
In the B column (5 onwards) i want it to open the said spreadsheet for each folder location adjactent to the column its on.
Its laid out like
A B C.. AA
5 Name1 *MY PROBLEM* C:\Folder\Name1\
6 Name2 *MY PROBLEM* C:\Folder\Name2\
So in the B column it needs to reference the folder specified in AA\Monthly engagement measure.xlsm.
Tried the google to no avail! Can anyone sped some light on this please?
*EDIT* I realise the column names dont line up..not sure how i can do that either haha.
A column lines up with the Names
B Column with My Problem
C onwards is other stuff not related
AA is the folder locations
Each one of these folders contain a file called 'Monthly engagement measure.xlsm'.
In the B column (5 onwards) i want it to open the said spreadsheet for each folder location adjactent to the column its on.
Its laid out like
A B C.. AA
5 Name1 *MY PROBLEM* C:\Folder\Name1\
6 Name2 *MY PROBLEM* C:\Folder\Name2\
So in the B column it needs to reference the folder specified in AA\Monthly engagement measure.xlsm.
Tried the google to no avail! Can anyone sped some light on this please?
*EDIT* I realise the column names dont line up..not sure how i can do that either haha.
A column lines up with the Names
B Column with My Problem
C onwards is other stuff not related
AA is the folder locations