Hello there,
Some advice please. I have a workbook with two sheets: Master and Profile. I want to create a button in Master which opens a dialogue box that allows users to browse to other Excel files. The user chooses their file and the contents are automatically copied and pasted into the Profile worksheet without the source file being opened.
I don't want to import the whole sheet, because I need Profile to retain its name but be overwritten with data from the selected source file. Ideally, the file browsing would start at a particular folder location and allow searching in subfolders.
Can someone recommend some VBA code that will do the trick please?
Thank you,
Russell
Some advice please. I have a workbook with two sheets: Master and Profile. I want to create a button in Master which opens a dialogue box that allows users to browse to other Excel files. The user chooses their file and the contents are automatically copied and pasted into the Profile worksheet without the source file being opened.
I don't want to import the whole sheet, because I need Profile to retain its name but be overwritten with data from the selected source file. Ideally, the file browsing would start at a particular folder location and allow searching in subfolders.
Can someone recommend some VBA code that will do the trick please?
Thank you,
Russell
