Mikeymike_W
Board Regular
- Joined
- Feb 25, 2016
- Messages
- 171
Hi,
I want to create a spreadsheet that will pull data from a form that my clients use.
There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename)
I want to copy the exact same cells from sheet 3 in the form to the new spreadsheet.
There will be many of these forms within the folder at one time. Can the code read all of these and add a new line in the spreadsheet for each form with one click?
I realise I'm asking a lot but I'm hoping the excel gods are watching over me
Many thanks in advance,
Mike
I want to create a spreadsheet that will pull data from a form that my clients use.
There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename)
I want to copy the exact same cells from sheet 3 in the form to the new spreadsheet.
There will be many of these forms within the folder at one time. Can the code read all of these and add a new line in the spreadsheet for each form with one click?
I realise I'm asking a lot but I'm hoping the excel gods are watching over me
Many thanks in advance,
Mike