Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it?
This is an example of the data in sheet2 (where the content is that the userhighlights)
This is where I want the highlighted rows to appear with the same highlighting color (called it sheet1).
Any help would be appreciated. Thank you.
This is an example of the data in sheet2 (where the content is that the userhighlights)
This is where I want the highlighted rows to appear with the same highlighting color (called it sheet1).
Any help would be appreciated. Thank you.
