Referencing other sheets
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!
Help Article Resources
Check out the Formula Handbook template!