Hi guys,
I am very new to VBA Macro's and kinda on a tight schedule, which is why any input will be helpful!! I have looked at multiple other posts and threads relating to similar situations, however i have not been able to adapt the macro's to what i need.
The Excel file which i want to gather the data is called "SavingsDatabase". It should gather the data from multiple Excel sheets which all have the same format within a specified folder using a command button. (all .xlsm).
To take an example, within the SavingsDatabase i would press a command button which will then locate the cell "Project Title" (C,4) from all the files within the specified folder and paste within cell (A,4) then (A,5 etc..) in the SavingsDatabase file.
I couldn't attach any of the files, however i have posted the same problem here:
VBA Macro - One Excel sheet which extracts information from multiple sheets.
Thank's again guys.
I am very new to VBA Macro's and kinda on a tight schedule, which is why any input will be helpful!! I have looked at multiple other posts and threads relating to similar situations, however i have not been able to adapt the macro's to what i need.
The Excel file which i want to gather the data is called "SavingsDatabase". It should gather the data from multiple Excel sheets which all have the same format within a specified folder using a command button. (all .xlsm).
To take an example, within the SavingsDatabase i would press a command button which will then locate the cell "Project Title" (C,4) from all the files within the specified folder and paste within cell (A,4) then (A,5 etc..) in the SavingsDatabase file.
I couldn't attach any of the files, however i have posted the same problem here:
VBA Macro - One Excel sheet which extracts information from multiple sheets.
Thank's again guys.
