| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy from one sheet to another and skip the blank rows
Select the whole range and filter the data on source sheet on any blank col Press F5, click on Special and select Visible Cells only Copy and then paste on the other sheet.. "Dawn" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy from one sheet to another and skip the blank rows
Genius. Spot on. thanx you have saved me a bunch of effort!
"Sheeloo" wrote: Select the whole range and filter the data on source sheet on any blank col Press F5, click on Special and select Visible Cells only Copy and then paste on the other sheet.. "Dawn" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy from one sheet to another and skip the blank rows
:-)
No, just someone with the required experience... Thanks for your feedback... "Dawn" wrote: Genius. Spot on. thanx you have saved me a bunch of effort! "Sheeloo" wrote: Select the whole range and filter the data on source sheet on any blank col Press F5, click on Special and select Visible Cells only Copy and then paste on the other sheet.. "Dawn" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
