I have another question in case anyone is still looking at this thread. (trying not to make another one so quickly)
If I were to email this file (Blue) to someone, will it record the reference and save it as a value rather than a formula? Stated plainly, will they see 109 or #REF! (or some...
Whoa, timeout. Nara's code actually worked!
You are the man NARA! THANK YOU SO MUCH!
Now for tweaking and implementation!
Thank you a million times over!
Thanks in advance for any help given, I am far from an Excel expert so any help at all is appreciated.
Onto the problem:
Let's say I have two workbooks Blue and Green. Green holds a running count of data entries with their entry number (102,103,104 etc). I would like Blue to be able to...