| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows in range if data in first cell
I need to select from a range of rows - only those having data (formula
result) in the first cell. There will be some rows without data in the first cell but they would contain a formula - these shoudl not be selected for copy. I want to select and copy all the rows having data in the first cell in order to paste these rows as values into a separate sheet in another workbook. Any suggestion? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a range of cells 15 rows down and repeat to empty cell | Excel Programming | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Read through Range and copy Cell data to Array | Excel Programming | |||
| Read through Range and copy Cell data to Array | Excel Programming | |||
| How to copy data in one cell into different rows | Excel Worksheet Functions | |||
![Wes_A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
