sheet1 gets new data added from an external source every 10 minutes.
Column G contains numbers. I need a macro to copy some of the numbers (i.e. >2 AND <5) to sheet2 column B, without empty cells, each time that sheet1 is updated with new data.
It sounds easy but I can't figure it out. How can I do it?
Column G contains numbers. I need a macro to copy some of the numbers (i.e. >2 AND <5) to sheet2 column B, without empty cells, each time that sheet1 is updated with new data.
It sounds easy but I can't figure it out. How can I do it?