I need to create simple software. It copies data from one programm, analyze it and inserts numbers to specified cells. I know how to copy.
Find data >= 1000 and < 5 000 000
Analyze and place data:
if value < 10 000, then place data “1”,
if value => 10 000 and < 15 000, then place data “2”,
if value => 15 000 and < 22 000, then place data “3”,
if value => 22 000 and < 33 000, then place data “4”,
Values “” should not be less than previous. For example, if previous value was 11 000, current value 8000, place “2” not “1”.