move data to another file

R

reza

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

move fill automatically to another file 1
Open & update another file (through macro) while running macro 1
merge data from 2 Excel files 0
macro required.. 1
VLOOKUP/Index&Match data format issue 3
Hyperlink error only in template file 0
How can I copy a value from a cell and paste it into another cell while adding it to the previous va 2
Transpose from Col to row 4

Top