i have a workbook named as "AHM".
in AHM i have two sheets namely "pl" and "pc".
in pl sheet there are 10 rows and 5 columns of data
in pc sheet there are 5 rows and 5 columns of data
in both of these sheets the rows may grow in daily basis

i have one more woorkbook named as "BAN"
in BAN i have two sheets namely "pl" and "pc".
in pl sheet there are 15 rows and 5 columns of data
in pc sheet there are 25 rows and 5 columns of data
in both of these sheets the rows may grow in daily basis

now the query is
i have a workbook named as "CON"
in CON there are two sheets namely "plwork" and "pcwork"
in plwork sheet i need the first two columns in pl sheet of both AHM and BAN and in pcwork sheet i need the first two columns in pc sheet of both AHM and BAN

is there any code to do the above task

you can mail me if there is any code to do the task
my mail id is [email protected]
and [email protected]

If you know how to do office programming in any language it is not a hard to pull of trick. Stipulations is that you need to know how to do office programming or programming at all. Now my query is- Do you?

Because if you do, than looking at some sample programe is all you need to do

http://msdn.microsoft.com/office/und...s/default.aspx
http://www.microsoft.com/downloads/d...displaylang=en

 and you will know how to do it.

But in case you dont.... well you are on this forum so i wont imagine that.

Regards
Ankur Verma

Hi in.ssuresh

I'm not quite understand what you really want to do?
Could you made some example?

ix