Hi there,

I'm wondering if someone can help me do this in a macro:

1. for rows 2 to the '$' symbol that it must find by itself (located in column A)

2. search columns A to '&' symbol that it must find by itself (located in row 1)

3. for the rows it finds from 2 to the $ sign, it looks to find the max and min value of each row

4. it stores the max and min value

5. it subtracts the min value of each row from each value of the row

6. it divides each value of the row by the (max value of the row - min value of the row)





eg of table.
_______col1 col2 col3 col4 col5 col6
row 1: Date Time Cash Car Other &
row 2: 12 34 56 78 90
row 3: 11 23 45 76 92
row 4: $

the program would only run from row 2 to 3 (before it finds '$' in col 1)
the program would only run from col 1 to col 5 (before it finds '&' in row A)

it would find for row 2: min = 12, max = 90, then it would subtract each value in row 2 by 12 and then divide all the entries by (90-12=78)
to change row 2 to: 0 0.282 0.564 0.846 1

it would find for row 3: min = 11, max = 92, then it would subtract each value in row 2 by 11 and then divide all the entries by (92-11=81)
to change row 3 to: 0 0.148 0.420 0.802 1