Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically move data to another file | Excel Discussion (Misc queries) | |||
Fill color of cells automatically change when file is opened | Excel Discussion (Misc queries) | |||
How do I automatically move down to the next row? | New Users to Excel | |||
fill the value in the cell when move the tab over | Excel Worksheet Functions | |||
Automatically move down to the next row | Excel Discussion (Misc queries) |