Hello Community!
I have created a worksheet that pulls data from my company's webpage that produces real-time information about our shipments. I have created very simple formulas that return how many packages are in the shipment and where they are going based on the data. So, for example, a formula might read (D2+D5)/3+D8. D2 might refer UPS shipment to Atlanta, D5 might refer DHL shipment going to Atlanta, D8 might refer to Fedex shipments to Atlanta. The good thing is my data is always lined up in the same column. My problem is when my data query refreshes sometimes row 5 is deleted. Say, the maximum amount of rows ever returned in the query is 10, well sometimes the query only returns 6 rows after a refresh because we haven't sent any shipments out via those methods. This completely throws off my formula. In my example, with data only being returned for 6 rows, there is no longer a D8, so of course I get a #ref error. Row 5 might no longer refer to DHL, but to USPS. Is there a way to write the formulas so they take into account the addition and deletion of rows?
Any help would be very much appreciated. I have google searched and found out all kinds of different thing I didn't know about web queries, but I haven't been able to find a solution to my problem, or I might have run across it but it was too complex for me to understand.
Thanks in advance for any assistance in this matter!
Bookmarks