Screenupdating excel performance
To help with the learning process I have added videos to show the steps involved.If you want to customize order and inventory management with userforms to your needs may I suggest that you go through the tutorials and get this working as I have created it and then customize the project? Select Protect_All On Error Go To 0 Exit Sub Adv Reorder_Error: Msg Box "Error " & Err. Description & ") in procedure Adv Reorder of Module Filters" End Sub '————————————————————————————— ' Procedure : Clear Data ' Author : Trevor ' Date : 22/06/2013 ' Purpose : '————————————————————————————— ' Sub Clear Data() On Error Go To Clear Data_Error Range("B25: I1000"). Show Protect_All On Error Go To 0 End Sub There are four advanced filters in this application one is in the assorted module and three are in the filter module.Only quirk is IA State's site does not archive special reports, only hourly observations.Advantage to wunderground is they archive this data. Were you able to use the IA state data without having to parse the METAR string? I discovered a compile error in my posted code, caused by a missing Dim statement.
(Remember, if you have a parameter query in Access already, this will create an error if we try to use it in Excel. Move on three screens making no changes until you arrive at the final screen (below).Wondering if it's possible to import a weather METAR from to the selected cell based on the date/time in the same row? Yes, I currently have over 1600 entries and the list will continue to grow. The goal is to preserve the data in it's originial state. My data set goes back to 2003, so I was hoping to not have a separate sheet or whatever of 10 years of METARs.I've included my workbook, which includes a sample macro for pulling data from wundergound. Currently, I'll go to the wunderground site and copy/paste the specific METAR into my sheet and parse the results. The first is doing a bulk update of the 1600 rows you currently have. For the first one, I would look at possibly getting a bulk dump of data.The function could easily be tweaked to return the entire line instead of just the METAR string.==========edited by aikimark to add Dim str Result As String Works great!