I have yet another burning question regarding macros this time. I am trying to build a macro which detects a new row of data added, which are data drawn from a web query.
This web query draws rows of data based on countries, and there might be new countries each time it is refreshed in the workbook. I would like to use my copy and paste macro to paste country data into another sheet in the same workbook. However, my copy paste macro only pastes data based on the top row countries (eg A1 = Argentina), but does not detect if there are new country data drawn from the web query.
Is there anyone that knows how to build a macro which detects the new country row?
Also, I would like the macro to show a notification to tell the user that there is a new country found (e.g. Country A is new, please insert a new column).