chris9277
02-04-2011, 02:04 PM
Hi,
I have hardly no experience with VBA so please bear with me as I have been told formulas can not work for this.
I have a file called "Idle Time Monitor" & within this file I have a workbook called "Master Sheet" then a load of other files which are exported into this file on a daily basis which are produced into workbooks named like this:
DispatcherActions_20090827_Employee_187.xls DispatcherActions_20100125_Employee_113.xls DispatcherActions_20100125_Employee_205.xls DispatcherActions_20100125_Employee_250.xls DispatcherActions_20100125_Employee_251.xls DispatcherActions_20100928_Employee_150.xls DispatcherActions_20110124_Employee_169.xls DispatcherActions_20110125_Employee_169.xls DispatcherActions_20110126_Employee_169.xls DispatcherActions_20110127_Employee_169.xls DispatcherActions_20110202_Employee_169.xls DispatcherActions_20110204_Employee_113.xls DispatcherActions_20110204_Employee_206.xls
Now what I would like to happen if possible is in the "Master Sheet" workbook I have a row of tabs each one labelled with the last 3 digits of the above file names so for example tab one is "data analysis" which I would like to attach the macro button to but then all other tabs are named "113", "169","205", "250", & so on. What I would hope I could do is everysheet has the same layout as the next & whenever a date is keyed into B4 (in reverse format 20110127) in each sheet it would look at the matching numbers in the middle of the worksheets & pull the information from H2 to I102 within the matching sheet & paste it into A7 to B107 of the matching tab of the "Master Sheet".
Now I know VBA can do alsorts, but is it possible it can do the above or would I have to change my "Master Sheet" slightly to accomodate this.
HELP VERY MUCH APPRECIATED.
I have hardly no experience with VBA so please bear with me as I have been told formulas can not work for this.
I have a file called "Idle Time Monitor" & within this file I have a workbook called "Master Sheet" then a load of other files which are exported into this file on a daily basis which are produced into workbooks named like this:
DispatcherActions_20090827_Employee_187.xls DispatcherActions_20100125_Employee_113.xls DispatcherActions_20100125_Employee_205.xls DispatcherActions_20100125_Employee_250.xls DispatcherActions_20100125_Employee_251.xls DispatcherActions_20100928_Employee_150.xls DispatcherActions_20110124_Employee_169.xls DispatcherActions_20110125_Employee_169.xls DispatcherActions_20110126_Employee_169.xls DispatcherActions_20110127_Employee_169.xls DispatcherActions_20110202_Employee_169.xls DispatcherActions_20110204_Employee_113.xls DispatcherActions_20110204_Employee_206.xls
Now what I would like to happen if possible is in the "Master Sheet" workbook I have a row of tabs each one labelled with the last 3 digits of the above file names so for example tab one is "data analysis" which I would like to attach the macro button to but then all other tabs are named "113", "169","205", "250", & so on. What I would hope I could do is everysheet has the same layout as the next & whenever a date is keyed into B4 (in reverse format 20110127) in each sheet it would look at the matching numbers in the middle of the worksheets & pull the information from H2 to I102 within the matching sheet & paste it into A7 to B107 of the matching tab of the "Master Sheet".
Now I know VBA can do alsorts, but is it possible it can do the above or would I have to change my "Master Sheet" slightly to accomodate this.
HELP VERY MUCH APPRECIATED.