Referencing other sheets

CherylAK

Ok I have one sheet that I have a formula in that references the data in another sheet.

 

The name of the source sheet is "Drug Seizures"

When I start my formula in the destination sheet, I click on reference other sheet, select "Drug Seizures" and then the data I want to reference.

When I look at the formula in the destination sheet...it is calling my source sheet "STREET Drug Seizures"

The name of the sheet is Drug Seizures, not STREET Drug Seizures.  Why is it adding the word STREET?

This one has me puzzled!

 

Thanks!

 

Paul Newcome

That is odd. Can you post some screenshots?

Has the sheet ever been called "STREET Drug Seizures"?

CherylAK

It is possible it was named that at one time.  I had "saved as new" and then renamed the sheets.  I deleted those and just have the 2 sheets now.  Is it possible it could be a fluke?  The formula is working great when data is put in the Drug Seizure sheet, but the sheet name in the formula is incorrect.

I hope you can see it in my screen shot.

 

Thanks!

Paul Newcome

When you "Saved as New", were the formulas already there?

CherylAK

Yes