Results 1 to 3 of 3

Coyping down merged cell that references non merged cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    78

    Coyping down merged cell that references non merged cell

    I have a cell that is merged with 4 rows. That cell references a cell that is not merged. I want to be able to drag the merged cell down the column on my spreadsheet and have it populate from list data on the referenced sheet. Currently it isn't progressing to the next cell when I drag it down on the referenced sheet, instead it's progressing down 4 cells (# of merged cells). Is there anyway to make it increment by 1 cell? Thanks!!
    Last edited by dta1984; 11-02-2011 at 10:06 AM.

Thread Information

Users Browsing this Thread

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

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