+ Reply to Thread
Results 1 to 6 of 6

Linked Cells

  1. #1
    Registered User
    Join Date
    07-11-2006
    Posts
    4

    Linked Cells

    Is it possible to drag the cell with a formula in it so that it can be repeated with a pattern changing?

    Might sound confusing, what I mean is can i put
    'worksheet name'!A2 and then 'worksheet name'!A3 to the right of it and then select both and drag to the right so that the number goes up while the letter stays the same.

    I've tried using $ to make it absolute but excel just keeps repeating the same two squares without changing the number.

  2. #2
    Gord Dibben
    Guest

    Re: Linked Cells

    You can't do it that way. OK dragging down a column but not across a row

    Enter in B1

    =INDIRECT("'worksheet name'!A" & COLUMN())

    Drag/copy across.


    Gord Dibben MS Excel MVP

    On Tue, 11 Jul 2006 19:08:41 -0400, tpsstudent
    <tpsstudent.2at02v_1152659409.7415@excelforum-nospam.com> wrote:

    >
    >Is it possible to drag the cell with a formula in it so that it can be
    >repeated with a pattern changing?
    >
    >Might sound confusing, what I mean is can i put
    >'worksheet name'!A2 and then 'worksheet name'!A3 to the right of it and
    >then select both and drag to the right so that the number goes up while
    >the letter stays the same.
    >
    >I've tried using $ to make it absolute but excel just keeps repeating
    >the same two squares without changing the number.



  3. #3
    Registered User
    Join Date
    07-11-2006
    Posts
    4

    Indirect Usage

    What would I fill in the column area with?

  4. #4
    Gord Dibben
    Guest

    Re: Linked Cells

    Don't know what you mean.

    Can you elaborate a bit, please.

    In your original, you wanted to transpose column data to row data.

    Fill in the column area with whatever you want your formulas to return.


    Gord Dibben MS Excel MVP

    On Tue, 11 Jul 2006 19:51:58 -0400, tpsstudent
    <tpsstudent.2at25v_1152662109.6083@excelforum-nospam.com> wrote:

    >
    >What would I fill in the column area with?



  5. #5
    Registered User
    Join Date
    07-11-2006
    Posts
    4
    I'm Sorry, I mean in the formula that you posted originally

    =INDIRECT("'worksheet name'!A" & COLUMN())

    What would I put in the parenthesis after COLUMN? so that it would count the correct number or columns?

  6. #6
    Gord Dibben
    Guest

    Re: Linked Cells

    You put nothing in the () after COLUMN(see last sentence of this post for
    exceptions)

    COLUMN() is a worksheet function that requires no arguments.

    =COLUMN() just returns the number of whatever column it is entered.

    If you enter the formula in A1 you would return the value from worksheet name!A1

    If entered in B1 you would return the value from worksheet name!A2

    Drag/copy across to return A3, A4, A5 up to A256

    ROW() works the same down a column.

    You could start at D1 column and enter COLUMN(-3) which is 3 columns left of
    D..............column A


    Gord


    On Wed, 12 Jul 2006 18:30:36 -0400, tpsstudent
    <tpsstudent.2aut4j_1152743708.9063@excelforum-nospam.com> wrote:

    >
    >I'm Sorry, I mean in the formula that you posted originally
    >
    >=INDIRECT("'worksheet name'!A" & COLUMN())
    >
    >What would I put in the parenthesis after COLUMN? so that it would
    >count the correct number or columns?



+ Reply to Thread

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