+ Reply to Thread
Results 1 to 3 of 3

Worksheet function to Autofill formula in column A when data entered in column B

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Galway, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    34

    Worksheet function to Autofill formula in column A when data entered in column B

    Hi
    I have a formula in cell A1 a which is locked. When I enter a value I into B1, I want the formula to AutoFill down to A2, when I put a value into B2 I want to formula to autofill down to A3 etc...... Is it possible through VBA worksheet code to handle this?
    thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Worksheet function to Autofill formula in column A when data entered in column B

    I'm sure it is possible through VBA or any number of other techniques to do something generic like this.

    I'm guessing there are details that I'm missing, but it seems like the easiest might be the =IF() worksheet function rather than VBA http://office.microsoft.com/en-us/ex...994.aspx?CTT=1
    A2 could maybe be something like =IF(isempty(B1),"",B1). Copy down the column as far as needed. As values are added to column B, they will be reflected in column A one row below.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Worksheet function to Autofill formula in column A when data entered in column B

    Try this :
    Please Login or Register  to view this content.

+ 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