Copy form one sheet to different sheet in another xl

Hi There,

I do have one big conciliated sheet from where I need to copy on each individual sheet.

For example in conciliated sheet there are coolum like name eeno and branch.
and I need to copy these details on there respective branch sheet in another xl.

I have copied both sheet for reference.

I have tried all possible way to search these threads but not found any suitable solution.

It would be great if some body help me out of these.


Thanks in advance.
Sandy

I know this is not the programming forum, but issues like this I always use a little macro to do the job. I've adapted it for your needs.

Please Login or Register  to view this content.

The macro is designed to work with your sheets as you've shown them. I've highlighted the parts of the code you would need to edit / change to match your actual working sheets.

=============
How to install the macro:

1. Open up your "attand.xls" workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

Hi JB,

sorry for asking again but this is not working at all.

OK, it's not working. I'm not sure if I see a question. How about posting up your new workbook with your attempted use of the macro and I'll take a look.