Thread: Bring values over from one excel sheet to another

Hey everyone its peeb, I haven't been on the barn for a while. My duties have switch more towards the business side rather than programming.

But I have a little problem, I have an excel sheet that has to sheets (sheet1, sheet2). I have multiple merged cells on Sheet1 that i'm trying to bring those values entered into those cells over to Sheet2 automatically. Or populate the merged cells I have in sheet2 with the values from sheet1.

I'm using the forumla of ='Sheet1'!E13:N13 on my Sheet2 to bring the value over, but its not working.

Is there another way I can do this? Does anyone else have any other suggestions? Any ideas would be greatly appreciative.

hey everyone, I was able to get it to work apparantly it was a bug in Excel 2007. Thanks

Thanks for the reply, but the cells that I was using were merged cells. SO I un merged them into a single cell. Used the formula and it worked and then I merged the cells again from 1 cell to merged multiple cells. It works, I thought it may have been a but in 2007.