Reference information from one sheet to a second sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
This must mean that the corresponding cell in the 2006 sheet is empty
Try =IF(ISBLANK(2006!B3),'"",2006!B3)
That a pair of double quotes between the commas.
If you later have a sheet name with spaces in it, you will need single
quotes around the sheet name as in 'Year 2006'!B3
best wishes
 
It sounds as if you only have data up to row 23 in your 2006 sheet -
thereafter, Excel will insert a 0 if the cell is blank on the sheet you
are bringing data from. To prevent this happening, you can amend your
formula to:

=IF('2006'!B3 = "","",'2006'!B3))

then copy this down and across.

Hope this helps.

Pete
 
Back
Top