Results 1 to 2 of 2

Thread: Please help with cell reference

  1. #1

    Please help with cell reference



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello guys!
    There's one thing I'd like to do but I keep failing.
    I have a data array in a sheet, and bellow this array I'd like to use some of those data by copy-pasting them in the same sheet. Everything would be simple when using a cell reference function, however, I need those data would be automatically pasted into different cells (like H30, H35, H40, etc.) from a sequence above (like C7, C8, C9, etc.). Whatever I'd do, I just keep resulting to a regular cells' referencing. If I show C7 in the cell H30, I cannot achieve H35 would show C8 and H40 would show C9 like I need. Instead, the result is as follows: H30 shows C7, H35 shows C12, H40 shows C17. What should I do to achieve the formula would take the data from a sequence by adding +1 cell only for next pasting and not +X cells accordingly?

    Thank you in advance!
    Last edited by moodestas; 2017-01-30 at 02:00 PM.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try, in H30:

    =INDEX(C:C,ROW()/5+1)

    then copy this cell to H35, H40, etc...

    or you can enter this formula in H30:

    =IF(MOD(ROW()/5,1)>0,"",INDEX(C:C,ROW()/5+1))

    and copy down to fill every 5 cells with a value....


Tags for this Thread

Posting Permissions

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