+ Reply to Thread
Results 1 to 7 of 7

formula to drag horizontally to equal vertical cells

  1. #1
    Registered User
    Join Date
    06-17-2008
    MS-Off Ver
    Excel 2003
    Posts
    30

    formula to drag horizontally to equal vertical cells

    Hi all....

    need a little help with this, I'm sure its possible but my excel skills aren't up to snuff

    I'm trying to get cells in sheet 1 across a row to equal cells that are listed vertically on sheet 2.

    So for example, I want A1 on sheet 1 to equal A1 on sheet 2, but then I want B1 on sheet 1 to equal A2 on sheet two. I want to drag a formula horizontaly in sheet 1 across about 100 columns. Anyone know the easiest way to create a dragable formula to do this?

    Thanks in advance.
    Last edited by VBA Noob; 09-15-2008 at 01:07 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    formula to drag horizontally to equal vertical cells

    Try this....

    On Sheet1
    Please Login or Register  to view this content.
    Copy A1 across to the right as far as you need.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    06-17-2008
    MS-Off Ver
    Excel 2003
    Posts
    30

    ...not quite

    thanks for the quick reply Ron - but not quite,

    Sheet 1 is actually called 'charts' and sheet 2 is actually called 'Actuals'

    The vertical data on 'Actuals' is in range L5:L105 and I want to put the data starting on charts AQ23 and drag it to the right.

    I adjusted the formula to read this and put it in 'Charts' AQ23


    =INDEX(Actuals!$L5:$L105,COLUMNS($l5:$l105))

    ...the first cell is correct, but something is still a bit askew when I drag it across.

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Using formulas to convert column data to a row

    Ok...that additional information helps...

    Try this:
    Please Login or Register  to view this content.
    Copy AQ23 across to the right.

    Is that something you can work with?

  5. #5
    Registered User
    Join Date
    06-17-2008
    MS-Off Ver
    Excel 2003
    Posts
    30

    Talking Works perfectly!

    thanks alot.

  6. #6
    Registered User
    Join Date
    05-14-2015
    Location
    south lake tahoe
    MS-Off Ver
    MAC 2011
    Posts
    1

    Re: Using formulas to convert column data to a row

    Can you help me understand this answer? I cant get the formula to work proper.
    I want row a1 thru a10 on sheet 1 to be column a1 thru M10 on sheet 2.

    should be so simply, but i am getting an error...

  7. #7
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: formula to drag horizontally to equal vertical cells

    @CIAOBMEBELLA
    please start a new thread with a sample file and more explanation.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How Eliminate "0"s in Formula Cells
    By TomBrooklyn in forum Excel General
    Replies: 3
    Last Post: 07-31-2008, 07:34 PM
  2. coloring specific cells using a formula - Excel Mobile
    By cosmicgrooves in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2008, 04:45 AM
  3. evaluate empty cells as zero in formula?
    By chrisb117 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2008, 08:15 AM
  4. Multiple cells referred to in IF formula query
    By Danofire in forum Excel General
    Replies: 5
    Last Post: 06-24-2008, 07:00 PM
  5. Replies: 1
    Last Post: 09-10-2007, 09:20 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