Hi cb,

Put 1 in G70
Then Highlight G1 to G70
Grab the fill handle and drag down to the end of your data,
hold down Ctrl before you let go of the fill handle

Then select all of your data and go to DataFilterAutofilter
On the G dropdown select 1

HTH
Martin


"cbpfaff" wrote in message
...
empty cells for the 70th selections. column G. What I have is a
selection
of transactions that I want to select every 70th one. I have a population
of
685 transactions. The cell with the transaction will not be replaced.

"Gord Dibben" wrote:

What is currently in each 70th cell?

Which column?

If using Excel 2007, which row?

Would any data be replaced or would the symbol be appended to existing
data?

Would the appending be ahead of existing data or following?

What type of symbol?

A macro could do it easily but to tailor it to your needs, please provide
some
more detail.


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 16:25:01 -0800, cbpfaff

wrote:

I want to have the program select every 70th cell and put a symbol in
it.
The population is 685 cells. Can excel do this with out me having to
move
and manually select?