delete rows?

T

tjtjjtjt

Is it possible to delete rows based on a pattern? I've inherited several large workesheets, and I need to add several hundred numbers on each sheet. Problem is, they are not contiguous.
The numbers I need to add are in the same column but appear in every 6th row. Is it possible to identify a starting row and then delete all rows in the way except the rows that contain the data I need?
I've duplicated the spreadsheet, so I won't lose anything.
I've also toyed with the idea of using the Autofilter, but numbers in some of the unnecessary rows are too similar to the values I need.
Thanks in advance.

tj
 
B

Biff

Try this:

Select the range.
Hit F5 or goto Edit>Go To
Click Special
Check Blanks
OK
Right click in the range
Click Delete
Check Shift cells up
OK

Biff
-----Original Message-----
Is it possible to delete rows based on a pattern? I've
Click to expand...
inherited several large workesheets, and I need to add
several hundred numbers on each sheet. Problem is, they
are not contiguous.
The numbers I need to add are in the same column but
Click to expand...
appear in every 6th row. Is it possible to identify a
starting row and then delete all rows in the way except
the rows that contain the data I need?
I've duplicated the spreadsheet, so I won't lose anything.
I've also toyed with the idea of using the Autofilter,
Click to expand...
but numbers in some of the unnecessary rows are too
similar to the values I need.
 
M

Max

... The numbers I need to add are in the same column
but appear in every 6th row...
Click to expand...

Let's say the numbers are located in col A in Sheet1
and the starting row for the addition is row7,
i.e. you want to add A7+A13+A19+ etc

In Sheet2
-------------
Put in say, A1: =OFFSET(Sheet1!$A$1,ROW(A1)*6,)

Copy A1 down to A3

This will extract the values in A7, A13 and A19 in Sheet1,
and so on, as you fill down col A

Now you could just use SUM() to add up all the figs

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
tjtjjtjt said:
Is it possible to delete rows based on a pattern? I've inherited several
Click to expand...
large workesheets, and I need to add several hundred numbers on each sheet.
Problem is, they are not contiguous.
The numbers I need to add are in the same column but appear in every 6th
Click to expand...
row. Is it possible to identify a starting row and then delete all rows in
the way except the rows that contain the data I need?
I've duplicated the spreadsheet, so I won't lose anything.
I've also toyed with the idea of using the Autofilter, but numbers in some
Click to expand...
of the unnecessary rows are too similar to the values I need.
 
T

tjtjjtjt

Thanks, Max, I'll give it a shot.
martialtiger, if I was a programmer, perhaps I could write that macro. Since I have little knowledge of VBA, that's not an option.

tj
 
Top