+ Reply to Thread
Results 1 to 3 of 3

Auto insert formula value when changes in column

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Auto insert formula value when changes in column

    Hi, i have create a getnumberonly function which will return all the number in a cell. Example, getnumberonly(abc123xyz) = 123

    however, i want to input this formula in Column C when there is a value/text in Column B. Like when someone type in ABG222 in B2, C2 will become 222 automatically.

    HOw can it be done in VB?

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Auto insert formula value when changes in column

    Can you not just put the formula in C2? =GETNUMBERONLY(B2)

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Re: Auto insert formula value when changes in column

    Can, however this sheet is a Data-Entry Sheet. And by right, its not COlumn C, its actually Column AE. I just wan a sample code from the expert and amend the column accordingly.

    It start from a Blank sheet with a header. FYI, in Column B, not all row will have data. Example B2, B19, B22, B38

    Currently, they using ifisblank in column AE, however, its still quite prone to manual mistake, like when data is in B4, they should key in the formula in AE4, however, they key in AE5 due to having to stroll left and right, very easy to read the wrong row. Morever, this is a Import file to import into our System. Sometimes, it will reject due to having "" in Column AE.
    Hence i wan to automate the Column AE

+ 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. [SOLVED] vba to insert formula and auto fill based on specific column A
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2018, 04:31 PM
  2. trying to insert a row and auto sum a column
    By kevin316 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-16-2014, 03:09 PM
  3. Auto Insert Row but Column Q Formula Not Working
    By MdYas in forum Excel General
    Replies: 1
    Last Post: 05-13-2014, 02:34 AM
  4. Complex VBA problem auto insert date and time, auto insert comment, etc.
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 09:40 PM
  5. Auto insert in a column
    By Camarlengo in forum Excel General
    Replies: 2
    Last Post: 08-20-2011, 04:11 PM
  6. Auto insert value in a column
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2008, 06:22 AM
  7. AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS
    By JLah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2006, 11:15 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