I have many cost centres in a department and i have many departments.
I am trying to create a workbook for each department with its various cost centres.
So what i need is a macro which will take the cost centre from a list and save it in one workbook as a worksheet and the name of the worksheet will be the cost centre.
Your help will be greatly appreciated..thanks
I am trying to create a workbook for each department with its various cost centres.
So what i need is a macro which will take the cost centre from a list and save it in one workbook as a worksheet and the name of the worksheet will be the cost centre.
Your help will be greatly appreciated..thanks