View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
cbpfaff cbpfaff is offline
external usenet poster
 
Posts: 3
Default How do I select every 70th cell and put a symbol in it?

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?