Thread: worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmh jmh is offline
external usenet poster
 
Posts: 2
Default worksheets

sheet1 is a summary page. sheets two thru 13 represent the months.on sheet 1
column 5 row 4 i've entered"=sheet2!r26. i would like to have that info
placed in the same row but different columns BUT I WANT column 6(the adjacent
column to read"=sheet3!r26". the next adj column i want to read
"=sheet4!r26". i would like this pattern to continue thru column 13. do i
have to do this manually?
--
thanx
jmh