| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one worksheet and disregard blank cells
I have data on one worksheet that needs to be copied onto another. The new
worksheet must have this data however it must diregard the blank cells. I cannot sort and then delete as each cell contains a formula that references another worksheet. a1 = abc a2 = def a3 = blank cell a4 = fgh a5 = ijk Many Thanks Allan new worksheet should read as a1 = abc a2 = def a3 = fgh a4 = ijk there is no longer a blank cell and the total rows has been reduced by the number of blank cells the original worksheet contained. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell value into blank cells below (full worksheet) | Excel Worksheet Functions | |||
| CSE formula disregard blank cells | Excel Worksheet Functions | |||
| Copy Data from Row 1 to last blank row in next worksheet | Excel Worksheet Functions | |||
| How do i make cells in one worksheet copy certain data to another | Excel Worksheet Functions | |||
| Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) | |||
Threaded Mode
