Other forum post with lots of information
If you view the above link you'll see what I have been working on. Which, by the way works amazingly for what I was a concept that I was messing with to a realization which I am grateful for. Which leads me to a new idea that I want to try and am curious if it is possible. On to the task at hand.
I currently have two excel databases that change based on my criteria. It's actually a serial number generator with each part having its own sheet and a log on the last sheet that the VBA is capturing/deleting duplicates (See above thread). What I want to do is combine these two databases into one workbook but instead of having the log in the same workbook I'd like to have it in another in real time. Would this be possible?