Hi all,
This had me scratching my head: at work, we're using a large-ish .xlsx file, with about 20K rows, with a lot of look-ups and so on. A messy job, but it's being kept in use due to, well, user reluctance to switch to an Access solution. You know the drill.
There is a manual operation...