This should be fairly easy but I'm new to VBA. I'm looking to standardize my data. In Sheet 1, I have my data, but I do not know how many columns or rows there are. I want to standardize that data and give the output of Sheet 2. Basically this is the (cell value-mean of the row)/(standard deviation of the row) for each cell. Finally I want to sum up all values in each column and paste it below. Thanks for your help!!!!!
Bookmarks