Report

Copy some columns from one excel sheet to oth

Ask a question rv_user_1 1Posts Tuesday February 22, 2011Registration date February 22, 2011 Last seen - Last answered on Feb 27, 2011 04:56PM
Hello,

I have got two excel files eg a.xls and b.xls i have to copy some column data from a.xls to b.xls . Both of these files have some common cloumns i have to copy some data from a particular of a.xls to b.xls.

For example i have a.xls like this
a b c
1 2 3

and b.xls looks like
x b c
3 5 7

now since b and c columns are present in both the sheets i have to copy the values of b and c cloumn of a.xls to b and c column of b.xls. I am new to This please help me....
See more 
Helpful
+0
moins plus
copy where ??

To make life easier, could you please upload a sample files WITH sample data, macro, formula , conditional formatting etc on some shared site like http://www.speedyshare.com/ , http://docs.google.com, http://wikisend.com/ etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!