+ Reply to Thread
Results 1 to 5 of 5

Thread: Bring values over from one excel sheet to another

  1. #1
    Barn Enthusiast peebman2000 is on a distinguished road peebman2000's Avatar
    Join Date
    Mar 2008
    Posts
    210
    Rep Power
    3

    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.

  2. #2
    Barn Enthusiast peebman2000 is on a distinguished road peebman2000's Avatar
    Join Date
    Mar 2008
    Posts
    210
    Rep Power
    3

    Reply

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

  3. #3
    aka RF; RadioactiveFrog grae.uk will become famous soon enough grae.uk's Avatar
    Join Date
    Oct 2008
    Posts
    144
    Rep Power
    2

    Quote Originally Posted by peebman2000 View Post
    hey everyone, I was able to get it to work apparantly it was a bug in Excel 2007. Thanks
    Hey,
    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. #4
    Barn Enthusiast peebman2000 is on a distinguished road peebman2000's Avatar
    Join Date
    Mar 2008
    Posts
    210
    Rep Power
    3

    reply

    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. #5
    aka RF; RadioactiveFrog grae.uk will become famous soon enough grae.uk's Avatar
    Join Date
    Oct 2008
    Posts
    144
    Rep Power
    2

    Quote Originally Posted by peebman2000 View Post
    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.
    Glad you have it sorted. Just thought I would comment on the apostrophe thing
    “There are two theories to argueing with women. Neither of them work! ” - Unknown

+ Reply to Thread

Similar Threads

  1. retreive DB values into a DD box
    By Centurion in forum ASP Development
    Replies: 9
    Last Post: March 31st, 2009, 07:33 AM
  2. getting values from tables
    By todd2006 in forum ASP Development
    Replies: 7
    Last Post: February 2nd, 2009, 06:33 PM
  3. Converting Null Values to Zero
    By nboscaino in forum Microsoft Access
    Replies: 3
    Last Post: September 4th, 2008, 01:02 PM
  4. finding values
    By todd2006 in forum ASP Development
    Replies: 2
    Last Post: June 23rd, 2008, 02:03 AM
  5. retrieve values
    By todd2006 in forum SQL Development
    Replies: 5
    Last Post: June 19th, 2008, 01:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO