HELP HELP!!
I need a macro code that upon opening of a workbook will open another workbook called "Master List". I then want the macro to search the "Staff Est" sheet in Column C for a determined cost centre number lets say "350" (i will need to change for each workbook) and where it finds this entry copy and paste all information back into the initial workbook into tab "Staff Est" starting in cell B2.
I then want the same thing for tabs "TRH" and "Schedule" pasting into A2 in tabs of the same name in the orginal workbook.
I can provide an example of both workbooks if required.
Can anyone help?!?!?!?!
I need a macro code that upon opening of a workbook will open another workbook called "Master List". I then want the macro to search the "Staff Est" sheet in Column C for a determined cost centre number lets say "350" (i will need to change for each workbook) and where it finds this entry copy and paste all information back into the initial workbook into tab "Staff Est" starting in cell B2.
I then want the same thing for tabs "TRH" and "Schedule" pasting into A2 in tabs of the same name in the orginal workbook.
I can provide an example of both workbooks if required.
Can anyone help?!?!?!?!
