Reference information from one sheet to a second sheet

[Kathleen]

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?

 

[Bernard Liengme]

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

 

[Difficult1]

How many rows do you have on sheet 2006?

 

[Pete_UK]

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