View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MEE MEE is offline
external usenet poster
 
Posts: 5
Default Copy line multiple times throughout spreadsheet?

I know this is probably one of the most basic functions, but I can't seem to
find an easy way to do it without having to manually do it myself. I have
created a basic worksheet for my users to track referrals. several column
headings such as date, customer name, referral comments, etc. with each new
row as a new referral. What I am trying to do is have it so that my column
headings repeat say every 5 or 10 rows, so that no matter how far down in the
sheet a user is, they can always see those column headings to be sure their
data gets into the correct column. is there an easy, automated way to do
this or am i stuck with copy / paste, copy / paste?

Thanks in advance folks!