B
Boss
Kindly help me on this..
I have 25 excel sheets saves in my C drive...
I wish to copy column z from first excel sheet & paste it col A of the new
sheet.
Then
I wish to copy column z from second excel sheet & paste it col B of the new
sheet.
Then
Col z of third sheet in Col C of new sheet
So on so forth till i fiinish my last 25th sheet.
This is something we can do manually but if we can do it using macro it
would be great.
Thanks a lot for help in advance..
Boss
I have 25 excel sheets saves in my C drive...
I wish to copy column z from first excel sheet & paste it col A of the new
sheet.
Then
I wish to copy column z from second excel sheet & paste it col B of the new
sheet.
Then
Col z of third sheet in Col C of new sheet
So on so forth till i fiinish my last 25th sheet.
This is something we can do manually but if we can do it using macro it
would be great.
Thanks a lot for help in advance..
Boss