66tigger40
Technical User
Hi
I have a spreadsheet that I need to do the following with:
Working down column C find the first Cell - get the value and then find the folder with that name on a particular drive, when it's found open a set file (always the same name in every folder).
When the file is opened copy a value from the first workbook into the first available blank cell in the worksheet.
Then loop through again until we reach a blank in column C
Is this possible?
Thanks
I have a spreadsheet that I need to do the following with:
Working down column C find the first Cell - get the value and then find the folder with that name on a particular drive, when it's found open a set file (always the same name in every folder).
When the file is opened copy a value from the first workbook into the first available blank cell in the worksheet.
Then loop through again until we reach a blank in column C
Is this possible?
Thanks