Results 1 to 3 of 3

Copy or reference data to merged cells

Threaded View

Scrap74 Copy or reference data to... 11-28-2013, 09:49 PM
humdingaling Re: Copy or reference data to... 11-28-2013, 09:59 PM
martindwilson Re: Copy or reference data to... 11-28-2013, 10:03 PM
  1. #1
    Registered User
    Join Date
    06-20-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Copy or reference data to merged cells

    So I have a sheet with data (data sheet). Each rows is a data points and the columns are metadata for each point.

    I want to split the data into 4 rows in another sheet (schedule sheet)so I can see the metadata across a timeline. EG, choose a data point to occur in a particular quarter and show metadata in the three rows below.

    I've tried merging rows in the schedule sheet and copy and paste data from data sheet, Excel doesn't allow copy into merged cells. I've also tried using cell references, but when copying references down the references jump by 4 rows.

    In the attached example, schedule sheet correctly reads A3, A4 & A5 when manually entered into cells A5, A9 & A13 respectively.

    When copying formula down from A13, the formula starts to jump 4 references
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Reference Cells into Merged Cells
    By Family Man in forum Excel General
    Replies: 6
    Last Post: 11-12-2013, 12:15 PM
  2. [SOLVED] Reference or Vlookup against merged cells
    By Deventus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2012, 11:48 AM
  3. [SOLVED] Copy Merged cells
    By diptis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 11:39 AM
  4. Copy data from a sheet and Paste in another sheet into Merged cells
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2011, 02:01 PM
  5. Reference to Merged Cells
    By excelhelp18 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2008, 10:49 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