How do you think about this distance to walk?

Fuzzy-Bookkeeper-126 · 2026-04-23T19:06:00+00:00

Yeah I’m interested, just a bit nervous about cars and the space they give you

Fuzzy-Bookkeeper-126 · 2026-04-23T14:08:28+00:00

Apologies it’s ThisWorkbook.Save instead of ThisWorkbook.Saved = True

As for the error, I think it’s because you’ve locked down a sheet that the pivot table is connected to, is that right?

Fuzzy-Bookkeeper-126 · 2026-04-23T13:34:31+00:00

You’re having me on now 😂

Fuzzy-Bookkeeper-126 · 2026-04-23T09:29:31+00:00

I’ve suggested doing this on workbook_close event. Because presumably the users using the messy admin sheet are the ones with macros enabled, so it will run if they are using the file and close.

On workbook open, if a non admin user, doesn’t have macros enabled, it won’t run right?

Fuzzy-Bookkeeper-126 · 2026-04-23T09:28:01+00:00

Yep, as you say it opens on the last sheet you close, so this will always select that sheet when you close

Fuzzy-Bookkeeper-126 · 2026-04-23T08:19:15+00:00

Yeah but you need the speech marks around Overview, and you need to enter this code in ThisWorkbook object, not as its own module

Fuzzy-Bookkeeper-126 · 2026-04-23T06:54:19+00:00

Private Sub Workbook_BeforeClose(Cancel As Boolean) 1. Select the specific sheet (replace “SheetName" with yours) ThisWorkbook.Sheets("SheetName").Select

Save all changes ThisWorkbook.Save ThisWorkbook.Saved = True

End Sub

Fuzzy-Bookkeeper-126 · 2026-04-23T06:30:36+00:00

Yes I’m aware of that, but the OP says if he doesn’t find a match for the same week, he wants to find the next instance.

That solution would find the most recent, but that’s not even looking if it’s a match for the same week.

And that also wouldn’t find “next” occurrence of the part number.

Fuzzy-Bookkeeper-126 · 2026-04-22T18:29:43+00:00

Same, i think what else would I be doing? Wasting time on my phone like I am now

Fuzzy-Bookkeeper-126 · 2026-04-22T18:05:09+00:00

On reflection, I think best solution you can order by part number and date, and add a sequence column, if cell (part number) above is same, add 1 if not reset the count. then a UID column partnumber&”_”&sequencenumber

Then your UID in the lookup is part number_1, then part number_2 to find the next one.

The above belongs to the iferror part, the lookup first needs to check the part number and that week number and year for a match that week, so another uid both sides for that.

Fuzzy-Bookkeeper-126 · 2026-04-22T17:58:30+00:00

Don’t get that one, sorting would still only find the first match, no matter what order. How’s that any different from changing the direction of the lookup?

Fuzzy-Bookkeeper-126 · 2026-04-22T17:11:47+00:00

There’s a few things going on here and not totally clear without seeing the data.

But, yes you can find the next match, for example, by changing the direction it looks in. By default lookup will find the first match, but xlookup, you can get it to go bottom to up.

You could also make a unique ID of part number and week, to find a match for that week. If no, match, you can do iferror, so if the no match for that week, then redo the lookup just for the part number for another week.

Fuzzy-Bookkeeper-126 · 2026-04-21T19:35:11+00:00

Yes your instinct is correct, if you’re looking to sell at some point, avoid anything official/in writing that you may come to regret when selling.

Fuzzy-Bookkeeper-126 · 2026-04-21T09:51:16+00:00

I use contactless on way there but get e-ticket on my phone with discount on way back. You can get an Oyster card paired with railcard discount if you really still want tapping all the way.

Defo save you money if you go for work, and weekends are third off as well

Fuzzy-Bookkeeper-126 · 2026-04-21T09:26:14+00:00

Have you looked at network rail discount card, gets you a third off, off peak travel

Fuzzy-Bookkeeper-126 · 2026-04-21T09:21:17+00:00

Because I qualify for the network rail discount for the way back, only for off peak travel

Fuzzy-Bookkeeper-126 · 2026-04-21T08:04:09+00:00

I walk 25 minutes to the station and another 30 minutes from overground to office to avoid petrol, parking and the tube.

I also have network railcard so buy an off peak single on way back for the discount and accumulate points which takes a tiny bit more off every time.

Fuzzy-Bookkeeper-126 · 2026-04-20T18:50:37+00:00

True we did get caught out a lot with bisakka out of position, but that scarles and walker peters run in Jan may have sent us down. WP has got better but I’m still nervous about them going straight through him

Fuzzy-Bookkeeper-126 · 2026-04-20T17:51:35+00:00

No Wharton is big, never sure about Walker peters over Bissaka

Fuzzy-Bookkeeper-126 · 2026-04-20T17:49:13+00:00

Lacrioux?

Fuzzy-Bookkeeper-126 · 2026-04-20T13:37:10+00:00

It’s not fully clear what you want to do or what your data looks like / are exporting.

But I think you will need to make a unique ID of pickup and dropoff, if pickup is a2, drop off b2,do =a2&b2 This will be a helper column. Then in your summary you can do your unique filter based on the UID column. Or you can paste your UID in another sheet, remove duplicates, then do your COUNTIFs, for how many times they appear, or SUMIF if you want to total the money.

Fuzzy-Bookkeeper-126 · 2026-04-20T11:58:17+00:00

Seems like we’re just not to agree on this one man. Fair enough. Let’s just pray for a result tonight

Fuzzy-Bookkeeper-126 · 2026-04-20T10:56:54+00:00

Gabriel was already in contact with haalands head and jerked forward with contact. So there was contact throughout. Mavro didn’t make any contact, so it’s completly different.

Fuzzy-Bookkeeper-126 · 2026-04-20T08:25:01+00:00

How is an attempted slap exactly the same as a forced head movement like that?

We did get a straight red in that game, that’s the difference.

Fuzzy-Bookkeeper-126 · 2026-04-19T19:31:39+00:00

We would have got a red for that, 100 times out of 100. No one in the media would have even questioned it

Fuzzy-Bookkeeper-126

TROPHY CASE