| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy from one sheet to another and skip the blank rows
I have a series of data in rows seperated by 3 blank rows and going down a
good few thousand rows. I am copying it into another worksheet without the blank rows. Is there a formula I can put in the second worksheet to look at the next cell on the first worksheet which is 4 rows from the previous and get the value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste data in different sheet but skip rows. | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| copy paste formula to skip rows | Excel Worksheet Functions | |||
| I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
| skip blank rows when pasting formulas | Excel Worksheet Functions | |||
Threaded Mode
