+ Reply to Thread
Results 1 to 3 of 3

Autofill: Change direction

  1. #1
    Registered User
    Join Date
    09-06-2008
    Location
    Germany
    Posts
    2

    Autofill: Change direction

    Hello everybody,

    Thanks for taking my question.

    I would like to autofill the following(either by using the autofill function or whatever other kind of solution):

    =RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)

    in a way that the column changes

    the result should look like this:

    =RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)
    =RIGHT(Tabelle2!B$4;LEN(Tabelle2!B$4)-FIND(":";Tabelle2!B$4)-1)
    =RIGHT(Tabelle2!C$4;LEN(Tabelle2!C$4)-FIND(":";Tabelle2!C$4)-1)
    .
    .
    .

    Yet, since I'm autofilling downwards (the formulas are in one column), it won't change anything. The number is not changing for the dollar signs - and this is okay. What I would like to change is the columns' reference.

    Is there any possibility to do this?

    Thanks for helping,

    Cheers,
    Andy
    Last edited by adonis85; 09-06-2008 at 08:20 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    =offset()

    If I understand correctly, as the formula is Copied down, column reference should increase.
    In that case, use something like this:
    =OFFSET(Tabelle2!A$4;0;ROWS(Tabelle2!$A$1:A1)-1)

    Hope this helped
    Ola

  3. #3
    Registered User
    Join Date
    09-06-2008
    Location
    Germany
    Posts
    2
    Quote Originally Posted by olasa View Post
    Hope this helped
    Ola
    This helped a lot!

    Thank you so much!

+ 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. Colour Change based on Text Value
    By Mark123456789 in forum Excel General
    Replies: 1
    Last Post: 12-04-2007, 05:52 PM
  2. Change date to word "present" change to red
    By soothing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2007, 02:38 PM
  3. Change Event doesn't change until I return to the Target Cell
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2007, 05:20 PM
  4. Cannot change default Comment font type
    By Komatsu in forum Excel General
    Replies: 1
    Last Post: 12-23-2006, 11:23 AM
  5. convert unit change to percentile rank change
    By dujang in forum Excel General
    Replies: 1
    Last Post: 11-15-2006, 02:53 PM

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