Good day everyone
I need your urgent assistance...
I have a excel table that has headings in column A and row 1
In the remainder of cells (column b- column z and row 2 - 20) there are values
I need to automate my process with the following steps
1. Identify all cells with Absolute values greater than 100
2. Highlight cells that meet criteria in step 1
3. For each of the highlighted cells I need to create a new table that shows:
3.1 the heading from row 1 in column A
3.2 the heading from the original data column A in column B
3.3 the amount from the highlighted cell in column C
I know my explanation is alittle confusing but will appreciate any feedback, thank you
I need your urgent assistance...
I have a excel table that has headings in column A and row 1
In the remainder of cells (column b- column z and row 2 - 20) there are values
I need to automate my process with the following steps
1. Identify all cells with Absolute values greater than 100
2. Highlight cells that meet criteria in step 1
3. For each of the highlighted cells I need to create a new table that shows:
3.1 the heading from row 1 in column A
3.2 the heading from the original data column A in column B
3.3 the amount from the highlighted cell in column C
I know my explanation is alittle confusing but will appreciate any feedback, thank you