| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move data w/o blank data to another sheet
Hi all....
i want to move data from sheet1 to another sheet, maybe it will need macro...hope you can help me. Example...in sheet1 i have: Line Col A Col B Col C Col D AA 10 5 4 1 BB 5 - - - FF 13 3 2 2 KK 10 - - - now in sheet2 i want to create resume from sheet1 automatically.... but i want if col B is empty or no data...it can't move to sheet2... so and in sheet2 Line Col A Col B Col C Col D AA 10 5 4 1 FF 13 3 2 2 thanks in advance reza |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move data w/o blank data to another sheet
There is no need to multi-post..You have a solution in General Questions
"reza" wrote: Hi all.... i want to move data from sheet1 to another sheet, maybe it will need macro...hope you can help me. Example...in sheet1 i have: Line Col A Col B Col C Col D AA 10 5 4 1 BB 5 - - - FF 13 3 2 2 KK 10 - - - now in sheet2 i want to create resume from sheet1 automatically.... but i want if col B is empty or no data...it can't move to sheet2... so and in sheet2 Line Col A Col B Col C Col D AA 10 5 4 1 FF 13 3 2 2 thanks in advance reza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move blank data | Excel Discussion (Misc queries) | |||
| Macro to delete blank rows and move data/info | Excel Discussion (Misc queries) | |||
| Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| Identify Blank Cells in Col & move coresponding data | Excel Programming | |||
Linear Mode
