View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MickinOz MickinOz is offline
external usenet poster
 
Posts: 2
Default copy a value across a row but into every nth cell

Say I have a table that has a variable (say$50) in cell 1 and is 12 months
wide (i.e. 13 cells across) I want to copy the variable into every nth cell
(where n is also a variable)
In this way I can say that certain expenses occur every n months.
Any suggestions greatly appreciated.
Mike