Hello Everyone,
I am currently working on an iterative macro to try and automate a process, but I have hit a roadblock. Currently, the workflow that I have put together is able to take in a number of data records, and then convert those records into a JSON payload which is then used with our API to automatically push data into a third-party website. Unfortunately, the functions for converting the records into a JSON payload only write out one line. We cannot do this process when there is more than one group at a time, since each group have their own URL on the website. This process works great for when we are only dealing with one group, but if we are dealing with multiple groups then the process is no longer suitable as we would have to copy out the functions for every group that we are dealing with.
Accordingly, we are now trying to create an iterative macro that can handle our data. This macro needs to be able to push our data through "X" number of times, with "X" being equal to the amount of unique values in Column A (Group ID).
I have attached an excel file below to give an idea of the data that we are handling. Thank you for your time, and I would greatly appreciate any kind of assistance in solving this issue.
