+ Post New Thread
Results 1 to 10 of 10
General Chat Thread, Excel help please? in General; I am trying to copy excel cells like this Code: =c5 =c15 =c25 Hard to explain but I have about ...
  1. #1
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30

    Excel help please?

    I am trying to copy excel cells like this
    Code:
    =c5
    =c15
    =c25
    Hard to explain but I have about 400 cells to fill and I can fill series as it jumps in just one step at a time.
    To make things more complicated I'm actually doing this in google docs!

    Can anyone help please?

    Thanks

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,581
    Thank Post
    724
    Thanked 1,684 Times in 1,499 Posts
    Rep Power
    432
    Do you mean you can't fill series?

    What step jump are you looking for as in Office 2010 you can set that I know you said you were doing it in google.

    A bit more info is required

    Ben

  3. #3
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30
    Sorry, I am finding it hard to explain what I want to do here!

    What I am trying to do is this...

    =concatenate(A503," ",B503) | =C505 | =E505
    =concatenate(A537," ",B537) | =C539 | =E539
    =concatenate(A571," ",B571) | =C573 | =E573

    And on and on!

  4. #4
    Flakes's Avatar
    Join Date
    Nov 2009
    Location
    Newcastle
    Posts
    476
    Thank Post
    38
    Thanked 74 Times in 48 Posts
    Rep Power
    27
    im confused just use the concatenate?

    dont think i know what you want, say you have these cells:

    ...A..B...C..D
    1..c..h...2..9
    2..e..f...u...h
    3..5..j...t....6

    what would you want as the result?

    do you mean you want to lock the co-ords in the concatenation?

    =concatenate($A$571$," ",$B$571$) | =C573 | =E573

  5. #5
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30
    See I told you I was finding it hard!
    I already have that in the six cells shown in my rubbish diagram but I now want to copy those down below stepping in steps of 34. When I try to fill series this doesn't carry on the steps of adding 34!

  6. #6

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    9,096
    Thank Post
    352
    Thanked 1,317 Times in 903 Posts
    Blog Entries
    4
    Rep Power
    1135
    If you select the cells where you have already entered the formula. You will see a small black box at the bottom right of the selection range [see attached picture]

    Click and drag this box out until you have populated the cells you want to have the copied formulas with the required values.

    Job done.
    Attached Thumbnails Attached Thumbnails Excel help please?-excel.jpg  

  7. #7
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30
    Quote Originally Posted by DaveP View Post
    If you select the cells where you have already entered the formula. You will see a small black box at the bottom right of the selection range [see attached picture]

    Click and drag this box out until you have populated the cells you want to have the copied formulas with the required values.

    Job done.
    That won't work for me! I think it is because it is a formula. If I just had
    a503
    a537
    a571
    I could do as you suggest and it works fine. but the minute it becomes a formula that doesn't happen!

  8. #8
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30
    Got it. I take out the equals sign. Then fill series and then do a replace to put the equals sign back in!

  9. #9

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    9,096
    Thank Post
    352
    Thanked 1,317 Times in 903 Posts
    Blog Entries
    4
    Rep Power
    1135
    Quote Originally Posted by reggiep View Post
    That won't work for me! I think it is because it is a formula. If I just had

    I could do as you suggest and it works fine. but the minute it becomes a formula that doesn't happen!
    How odd!. I have just used your formula [in one column only] and copied the values down with the following result [see attached]

    Excel help please?-excel2.jpg

    Does this not work for you?

  10. #10
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,490
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    I think that if you manually enter the first few rows, then highlight all of them and copy the formula down, Excel will carry on your +34 pattern. Might be wrong though...

SHARE:
+ Post New Thread

Similar Threads

  1. Excel custom function help please!
    By stupidusagi in forum Office Software
    Replies: 12
    Last Post: 2nd October 2011, 05:42 PM
  2. [MS Office - 2003] Excel expert required - Help please
    By elsiegee40 in forum Office Software
    Replies: 14
    Last Post: 17th May 2010, 08:23 AM
  3. Web page in open office or Excel help please.
    By MrWestwood in forum Office Software
    Replies: 0
    Last Post: 1st May 2009, 11:34 AM
  4. more excel help needed please
    By RabbieBurns in forum Office Software
    Replies: 10
    Last Post: 6th September 2008, 11:53 PM
  5. E Learning Credits - Help Please
    By MuppetQueen in forum Budgets and Expenditure
    Replies: 4
    Last Post: 12th December 2005, 03:10 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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