I have a data connection that pulls production data into an excel sheet and then I use that data to create an hourly production board. My IT department is URGING me to reduce the size of the connection. In an effort to do so, my thought is to pull less lines of data with each refresh, but I need a way to keep the data from the previous refresh. I currently use the macro shown below to refresh my connection (18,000 rows) and save the workbook every 15 minutes. The 18,000 rows gives me 24 hours worth of production data. What I'd like to do is to pull, say 1,000 lines every 15 minutes, but before doing that refresh, I would copy and paste the existing 1,000 lines to the first unused row on another sheet. The data is on sheet "T3DATA", columns A:R. Any help would be greatly appreciated.
I'd also like this macro to run automatically when this workbook is opened.
Sub SaveWb()
ThisWorkbook.RefreshAll
ThisWorkbook.Save
Application.OnTime Now + TimeValue("00:15:00"), "SaveWb"
End Sub
I'd also like this macro to run automatically when this workbook is opened.
Sub SaveWb()
ThisWorkbook.RefreshAll
ThisWorkbook.Save
Application.OnTime Now + TimeValue("00:15:00"), "SaveWb"
End Sub
Last edited:
