Help with referenced sheet (sorry for dups)

  • Thread starter Thread starter Bill L
  • Start date Start date
B

Bill L

Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ). I
start by creating the reference with sheet XYZ already existing, so that I
can pick the cells I want off of it. I then delete sheet XYZ. My cells on
ABC all then become #REF, which is okay with me. I save and close. I then
run the program that takes some data, opens my excel file, and (re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the #REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill
 
Worked like a charm!

Thanks!!


Don Guillett said:
To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
Back
Top