move data to another file
 

hi all,

i have 2 file, A.xls & B.xls
in A.xls, sheet1 i have data from AA50:AA200, but not all fill have
values...some of the are blank fill.
And now, i want to move that data automatically to B.xls. my requirement:
1. Only fill that have values will move to b.xls, blank/empty fill don't
move to b.xls
2. from AA50:AA100...move to b.xls to Column B, AA101:150 move to column C
and rest move to Column C...

hope you can help me....

thanks in advance


reza