Hi,

I have data spread over several columns across several sheets in excel file. The data starts from column C followed by its normal distribution function in the next column and so on. What I want to do is to autofill the normal distribution formula in all the cells (depending on the data size on its data column) and keeping the location of mean and standard deviation for the data column as relative (reative to last row), since now I use absolute reference scale.

Why I want that? I will have variations in the data column size and hence the ndf column needs to be modified and hence the references it uses in the formula for locating "mean" and "standard deviation". How will it be possible? The sample excel file is here: Sample.xlsx

The macro I've been using is not working, says "Reference Error" at autofill. The macro is pasted here:
Please Login or Register  to view this content.
Thanks in advance!