View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bonbon
 
Posts: n/a
Default Same colum different row?

How do i copy the same colum but one row down's values accross the workbook
repeatedly instead of keep changing the row number?
e.g. i want $E1, then $E2 etc accross the page.

Any help would be hugely appreciated =)