I'm a first timer here. normally can find what I need by just searching but this one is stumping me.
I have 2 sheets in the same work book but I would like to move them to there own work book.
I'm trying to search column B in the NEW KITS sheet using a Name Manager in a separate work book.
I changed the formula from(Name Manager):
='NEW KITS'!B1953:B10000
To(Name Manager):
='\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000
but after i made the change I get a #VALUE! error.
any ideas? thanks!
I have 2 sheets in the same work book but I would like to move them to there own work book.
I'm trying to search column B in the NEW KITS sheet using a Name Manager in a separate work book.
I changed the formula from(Name Manager):
='NEW KITS'!B1953:B10000
To(Name Manager):
='\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000
but after i made the change I get a #VALUE! error.
any ideas? thanks!