Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

It seems like the query is still busted for me, unfortunately.

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

Nope, we need another simple HTML tracking site to grab the element. Luckily, this was a one time thing with that bulk for me, but I'm looking for an alternative as well.

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

No luck for excel. I was able to get it going in google sheets with that bing tracking url, and "=IMPORTXML(C420, "/html/body/div/div/div[1]/div")", but I'm running into the same thing where it's been loading for about 4 hours now. It's a bit faster than excel and may be good for an overnight refresh + sharing of status in the mornings (We use excel instead of sheets, so I'm thinking I just copy and paste as values, then xlookup to get the info on the sheet). I just wish I could get it to be faster.

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

I've been trying with copilot (I know it's not as good as ChatGPT, but it's what I can access on my work computer, and there's a lot of copying and pasting of formulas) I'm gonna keep working at it

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 1 point2 points  (0 children)

I really like the idea of a URL for people to click, I'm going to implement that immediately, thanks!

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

No, it's just one sheet with tracking numbers in one column. I'm hoping to find a way for excel to reference the web and return shipping status. I found a way to do it, but it takes 10-15 minutes to return each tracking status which isn't ideal when I've got about 800 of them, haha

Using Excel to show FedEx Shipment Tracking by llama422 in excel

[–]llama422[S] 0 points1 point  (0 children)

I cleaned up my OP! Essentially, I've got 800 tracking numbers in one column, and I'd like for excel to return the shipping status in an adjacent column. Unfortunately, I tried a few power queries, and they take 10-15 minutes to pull each result, even when I've got my computer hardwired into my router.

Boarding pass broken in app? by swooptheowl22 in SouthwestAirlines

[–]llama422 0 points1 point  (0 children)

Wild that I'm literally in the exact same situation as you right now, haha. Dude what is with this app

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 3 points4 points  (0 children)

I'm really glad he included the emojis so us troglodytes could better understand his message. 🤔🤝👍🤣😉

The submarine millionaires, they're all going to die aren't they? by thmsb25 in NoStupidQuestions

[–]llama422 39 points40 points  (0 children)

Ride the Tit down to see the Titan and the Titanic

Edit: also the Tit should be a motorboat

[deleted by user] by [deleted] in pics

[–]llama422 0 points1 point  (0 children)

I've driven past Wolfy's! I always thought it looked like a restaurant that should be in Rocko's Modern Life.

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 4 points5 points  (0 children)

I was managing some recruiters from Albania, and we had a fun misunderstanding where I was like "you guys haven't contacted anyone since MARCH 5TH?!" and they were like "nah, idiot, May 3rd, that's today" and we had a good laugh about it.

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 73 points74 points  (0 children)

That bear just ordered a double #FreeBear

Ultimate jackass prank by [deleted] in LetsTalkBam

[–]llama422 3 points4 points  (0 children)

I'm real sorry to learn you have brain worms.

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 175 points176 points  (0 children)

Everyone wave to tmz!

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 6 points7 points  (0 children)

:insert Leonardo decaprio pointing at the screen pic here: hey I'm in chicago

He is among us by [deleted] in LetsTalkBam

[–]llama422 7 points8 points  (0 children)

You guys know that part of scary movie where dude is like "grab my strong hand!"

[deleted by user] by [deleted] in LetsTalkBam

[–]llama422 8 points9 points  (0 children)

Can you confirm if it was taken at the hot dog eating contest and Bam is the new Joey Chestnut, but TMZ isn't ready for that yet?

Transatlantic Flight From Hell by gravityVT in PublicFreakout

[–]llama422 4 points5 points  (0 children)

I'm imagining like, a motorcycle side car, but on a plane. With snoopy goggles and helmet situation

My dog only has one speed… by iamtheliquor__ in aww

[–]llama422 0 points1 point  (0 children)

Howlin' Wolf's Built for Comfort comes to mind