This is a discussion on Bring values over from one excel sheet to another within the Microsoft Office forums, part of the Operating Systems, Servers & Software category; Hey everyone its peeb, I haven't been on the barn for a while. My duties have switch more towards the ...
| |||||||
|
#1
| |||
| |||
| 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. |
|
#2
| |||
| |||
| hey everyone, I was able to get it to work apparantly it was a bug in Excel 2007. Thanks |
|
#3
| ||||
| ||||
| Quote:
Did you just remove the apostrophes? Not sure it is a bug ... i've always used something like this and it works fine ... =Sheet1!E13:N13
__________________ “There are two theories to argueing with women. Neither of them work! ” - Unknown |
|
#4
| |||
| |||
| 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. |
|
#5
| ||||
| ||||
| Quote:
|
![]() |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| retreive DB values into a DD box | Centurion | ASP Development | 9 | March 31st, 2009 07:33 AM |
| getting values from tables | todd2006 | ASP Development | 7 | February 2nd, 2009 06:33 PM |
| Converting Null Values to Zero | nboscaino | Microsoft Access | 3 | September 4th, 2008 01:02 PM |
| finding values | todd2006 | ASP Development | 2 | June 23rd, 2008 02:03 AM |
| retrieve values | todd2006 | SQL Development | 5 | June 19th, 2008 01:46 PM |