Forum Discussion
When Array table is updated/ sorted, the adjacent column cells aren't aligned/ linked
Perhaps the attached file will help you on your way.
Hi Riny,
What you have done is created a lookup table that has all my payee details and added the category next to it. This is exactly what i've done to get over with this problem. But, now my lookup table needs to be updated every time a new payee is added (brought from my bank statements). Earlier this used to be automatically updated from my statements using the unique function. Is there a way to still use unique function in the lookup table to have the payee list automictically updated and still be able to be linked with the category that i manually assign it to?
- Riny_van_EekelenJun 28, 2023Platinum Contributor
"Earlier this used to be automatically updated from my statements using the unique function"
When you say that, I wonder how. You need to explain more. What has changed since "earlier"?