View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kathleen
 
Posts: n/a
Default Reference information from one sheet to a second sheet

Hi
I have a spreadsheet titled 2006 on sheet one. This sheet has column a - v
with information. I want to have column b and I through s automatically fill
in on sheet 2. I was successful in using =(2006!b3) for the first column I
wanted to be on sheet 2 and it worked up until row 23 then only filled in
with 0 from there on. Any suggestions?