Hi, I am new to this forum so apologies for any non conformity. I have tried searching the web for an answer to this but I cannot come up with something.
I have a user form for entering data into a worksheet, the form identifies where the first blank cell in the column (say column A) is and adds the data into this, say there are fifty entries within this column add the user form adds the 51st - I am trying to take an average for the last 30 entries that moves with each entry and the average is inserted into a cell, say C1.
I hope this makes sense, and I would be very grateful for any help anyone could offer.
Cheers
RxFx10
I have a user form for entering data into a worksheet, the form identifies where the first blank cell in the column (say column A) is and adds the data into this, say there are fifty entries within this column add the user form adds the 51st - I am trying to take an average for the last 30 entries that moves with each entry and the average is inserted into a cell, say C1.
I hope this makes sense, and I would be very grateful for any help anyone could offer.
Cheers
RxFx10