Let's say I have an Excel file with 5 different sheets in the file. And let's say cell A2 in sheet 1 holds the same data as cell C5 in sheet 4. Is there a way to have excel automatically fill the data into cell C5 when I type it into cell A2? Thanks
v-look up. I'll send the formula tomorrow. It's at work. So sometime tomorrow so I don't forget reply to this post, i'll get the email and then post it for you.