Not quite sure how to explain this? I have an Excel sheet I use every day. I need to keep a 'live' copy of it so I do not have to copy and paste a vast amount of data at the end of each day. Is there a way to 'automate' the process so that every time I make a change during the day it automatically updates the copy?
I used to be able to do the above many years ago in Windows 95 but cannot for the life of me remember how I did it! (It's an age thing)