- Change cell reference mutliple sheets formula
- How to copy cells from one sheet to another in excel using formula - How-To - Excel
- How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
- How to change the same cell in multiple sheets - How-To - Excel
- Replace 'sheet' reference in a formula (not copy data, but get averages) ✓ - Forum - Excel
- Formula copy cell from one sheet to another ✓ - Forum - Excel
If sheet1 cell C5 is not empty then it will never go to Sheet2!C5 and will give the value of sheet1!C5 ..... make blank your sheet1!C5 then your formula will go onward ........ Just check and tell me if there is still problem .....