I am pulling in hourly weather data from a weather website. I am then using search and offset codes to select certain data that I want and copy and past it over to a new sheet. The problem is that every day about two hours until sunset, they data I am pulling in has a new row with the time for sunset. This throws off all of my offseting code after that row.
I need help trying to figure out the syntax where it it will search for "sunset" and if "sunset" is found it will delete entire row (so my offsets can continue to work), if no "sunset" exists (else) continue with code.
This is what I have so far....
The problem with this code is that the cell that contains "sunsetSunset" also has a time in the cell (like this sunsetSunset 9:01 p.m.), so my current code won't find and count the cell. The time constantly changes so it is not like I can hard code it.
Any help would be appreciated. Thanks.
Bookmarks