Sep 25 2023 07:20 PM
Sep 25 2023 11:27 PM - edited Sep 25 2023 11:36 PM
@Phil_TKREO -It's doable but a big effort. I can give you some pointers.
Limitations: a). We need to manually refresh the workbook once a new sheet is created as SHEETS() formula doesn't auto calculate. b). We need to be cautious when we delete a sheet as it can break the 3d reference range
I hope this helps!
Oct 01 2023 05:10 PM
@Phil_TKREO Thank you for your assistance. I will need to find a bit of time to work through the suggested process.