I have employees who use spreadsheets in different workbooks to indicate
their area's issues and I use a spreadsheet to combine the important pieces
into my own workbook. I want to have my workbook automatically update every
3-5 minutes without having to hit a refresh button.
Ultimately I'd like to have their workbooks do the same thing, so that I can
have cells that link from them to me and from me to them, so they can see
changes I'd like for them to make.
Can I use VBA to write a procedure to refresh the links? If it's possible,
can you write out the whole code I should use?; I'm not familiar enough with
VBA to do anything more than copy/paste and clap my hands with glee.