Hello everyone!

Here's the problem I'm having.

I have a computer/monitor in two separate spaces. The one in my space hosts a status board created in excel which contains data I need to replicate on the monitor in the other space so that it appears the data is being updated real time. The file is saved on a share drive which both computers can access.

For this I need a macro that will automatically save the file that I'm updating locally every time any change is made and then another one that when run will automatically refresh the file in the other space every ten seconds.

Problem is I have no idea how to do this because I have no understanding of any of this scripting stuff.

If anyone could help me with this it would be greatly appreciated. I am currently out to sea and with off ship connectivity speed it's extremely difficult to get any information without knowing where I'm going to get it.

Thank you!