I have an excelworkbook which has n number of worksheetssheets in it.
I have major sheet which has information pertainning to all the n sheets.
Now what i want to do is copy the particualr information from the major sheet to the particular sheet.
For Example i have ten different manager worksheets . The major sheet contains the data for all the managers.
I want to copy the filename of each manager and search it in the major sheet and copy the information related to him to his sheet.
Attached is the example.
Please help me on this its very urgent.
Thanks,
Salma
Bookmarks