Here at work we have an Excel spreadsheet that pulls information from a different program and puts it into specific cells on that worksheet.
Currently we have to push "F9" to get the spreadsheet to update and reflect the numbers that are on the other program. Is there a macro or formula that can be written so that the spreadsheet will automatically update every 5 or 10 minutes on its own? Any help will be greatly appreciated.
Currently we have to push "F9" to get the spreadsheet to update and reflect the numbers that are on the other program. Is there a macro or formula that can be written so that the spreadsheet will automatically update every 5 or 10 minutes on its own? Any help will be greatly appreciated.