move fill automatically to another file
 

Hi all

i have 2 file, A.xls dan B.xls
in A.xls in sheet1 i have data in coloum AA55:AA200.
now i want that data move to B.xls only for fill that have values..and for
blank fills don't move to B.xls
another requirement:
i want from AA55:AA100 will move to B.xls into sheet1 to coloum C and for
AA101:150 will move to B.xls into sheet1 to coloum D, and rest move to coloum
E.
hope you can helps me.

thank you and appreciate for your kindness.

reza

move fill automatically to another file
 

Take a look at this:
http://www.rondebruin.nl/copy5.htm

Instead of every 'record with the same value', substitute records that are
not blank, or <""

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"reza" wrote:

Hi all

i have 2 file, A.xls dan B.xls
in A.xls in sheet1 i have data in coloum AA55:AA200.
now i want that data move to B.xls only for fill that have values..and for
blank fills don't move to B.xls
another requirement:
i want from AA55:AA100 will move to B.xls into sheet1 to coloum C and for
AA101:150 will move to B.xls into sheet1 to coloum D, and rest move to coloum
E.
hope you can helps me.

thank you and appreciate for your kindness.

reza