I'm new to the forum and a beginner with programming in VBA.

I'm trying to take a matrix of data, say B2:K21 and re-scale it so that the values are between 0 and 1. The rows are respondents and the columns are answers to questions. I would like to first find the min and max for each respondent (row). I would then take these values and by row, change the raw data to something like: new_data = (raw_data - min)/(max-min). I then would output the new matrix of data to a different sheet.

Any example code would be appreciated.

Thanks.