| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one worksheet and disregard blank cells
Glad I could help
"Allan" wrote: Thanks Mike, Such a simple solution, that's probably why I couldn't findit. Thanks Again "Mike H" wrote: Allan, Select the top cell of your range then Data|Filter|AutoFilter On the Autofilter dropdown select 'Non Blanks' Select all your data and Copy paste it into the new location and the blank rows are gone Mike "Allan" wrote: 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
