PDA

View Full Version : Link two excel sheets


Jyoti Goel
Nov 29, 2013, 04:14 AM
Hello
I want to link two excel sheets, so that when ever I update, delete or add any anything or any row or column in first sheet, that will automatically update the same in second one also

pwooden
Nov 29, 2013, 06:15 AM
=Master!A1

If you have a worksheet called (say) master. The formula above will always update to hold the same value as A1 in that sheet.