https://drive.google.com/file/d/0B8BunA6SAooNbGJwd3hodkc5Qjg/view?usp=sharing
Ok this is my Sheet I am working with... What I want to do is on the "Looney Toons Data Sheet" I want to be able to enter "Pink" in "My Collection" column.. Then from this, it goes to the next sheet "Looney Toons Spares & Needed" and should mark what is numbered currectly "# 222" with a Spare Tazo... This works, IF I change "# 222" to "Pink"... This then goes to the next sheet "Looney Toons Overview" and sets it up.. However it doesn't work like that.. It still puts "# 222" regardless of what is actually typed... I am just wondering if there is a way around this?
Ok this is my Sheet I am working with... What I want to do is on the "Looney Toons Data Sheet" I want to be able to enter "Pink" in "My Collection" column.. Then from this, it goes to the next sheet "Looney Toons Spares & Needed" and should mark what is numbered currectly "# 222" with a Spare Tazo... This works, IF I change "# 222" to "Pink"... This then goes to the next sheet "Looney Toons Overview" and sets it up.. However it doesn't work like that.. It still puts "# 222" regardless of what is actually typed... I am just wondering if there is a way around this?
