find last value in column and copy then paste to another sheet.
Basically i have column C and it has a formula copied throughout from cell 4 to 4500, when data is entered into the table and the formula does its magic a value is displayed in the relevant cell in column C. i want to find the last cell in column C with a value and copy this and then paste the value to another sheet not the formula. ive tried a few things but failed. HELP please.