with macros it is possible to automate it, send a nonsensitive sample of the data and the expected result so we can guide you.