Hello.
I'm in urgent need of help here. Sorry if this question is elementary, I'm new to this.
In VBA I need to be able to have code that opens each Excel file in a folder, Selects All, Copies it, and pastes it into a new sheet on my main workbook. So basically one workbook would have all the data from separte workbooks, on individual sheets.
These separate workbooks only have one sheet of data I want to copy named "Main." So I need one workbook to have all the "Main" sheets from separte workbooks, pasted onto individual sheets.
Does anyone know of any code that can do this? Any help would be greatly appreciated! Thank you.
I'm in urgent need of help here. Sorry if this question is elementary, I'm new to this.
In VBA I need to be able to have code that opens each Excel file in a folder, Selects All, Copies it, and pastes it into a new sheet on my main workbook. So basically one workbook would have all the data from separte workbooks, on individual sheets.
These separate workbooks only have one sheet of data I want to copy named "Main." So I need one workbook to have all the "Main" sheets from separte workbooks, pasted onto individual sheets.
Does anyone know of any code that can do this? Any help would be greatly appreciated! Thank you.