Hey guys! At my firm we use excel linked to bloomberg, a trading software that provides market data. Problem is, the tables aren’t being updated so I was assigned with fixing it and I figured the best temporary way is to create a macro that refreshes cells in the table individually (refresh all doesn’t work) and have some system so it waits a period of time before moving onto the next cell and repeats when it fails. Can anyone give me any help in this? I don’t know Visual Basic but I have the general idea of what’s needed in my head.
Help the intern!