Hi there Orchimus,
Thank you for your quick reply, it is much appreciated, and I also do appreciate your sense of humour.
In order to get rid of the 0 value I added this bit (please see below) in the module, and it does work, so again, thanks for the catch
What you did is perfectly fine. Now, regarding your question, I am trying to run this for multiple input data at the same time if possible, so the question is: would the macro be able to run for the "Porsche" entry and generate new rows the same way as it does for the Ford Mustang for example? I have quite a few of data inputs like those 2, around 11k, so that's why I'm asking, otherwise I would have to run the macro for each input individually, like one at a time, like run for Ford Mustang, then wait to add the rows, and move on to the next input and so on. So I'd be more than grateful if you could let me know if there is any possibility to run the macro for the whole input data from row A2 onwards at the same time, such as not having to run it manually for each input separately.
Bookmarks