Results 1 to 6 of 6

Copy / drag formula to next nth row

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2010
    Posts
    44

    Red face Copy / drag formula to next nth row

    Hi guys,

    Please help, is there a formula wherein, if dragging it down 5 rows lower the cell reference should still be in series. example e3=+sheet1!$A1, dragging it down to e8 the formula should be e8=+sheet1!$A2, but as i do it the formula i get is e8=+sheet!$A6.

    please see attached file for clearer example.

    Thank you so much =)
    Attached Files Attached Files
    blessed are those who share whats theirs

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Copy/Drag Formula's - Need to Skip Rows
    By Rapacious in forum Excel General
    Replies: 3
    Last Post: 03-01-2012, 06:10 PM
  2. Copy and Drag formula!!
    By quikrich3 in forum Excel General
    Replies: 3
    Last Post: 06-17-2011, 12:41 PM
  3. Problem with Formula copy/drag
    By aspence in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2008, 03:53 PM
  4. [SOLVED] Copy Formula: How we can drag in a column?
    By Renee Nguy in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 01:55 PM
  5. Copy an Drag cell Formula Problem
    By Nat in forum Excel General
    Replies: 1
    Last Post: 06-20-2005, 11:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1