+ Reply to Thread
Results 1 to 4 of 4

Insert new column with a Formula

  1. #1
    Registered User
    Join Date
    08-16-2019
    Location
    Alicante
    MS-Off Ver
    MS 2019
    Posts
    6

    Insert new column with a Formula

    Hello

    Information:
    Excel with data (amounts and text) from column A to AQ.
    Columns needed for the forumla are:
    Column C [Document Type] with text or empty
    Column X [FA Posting Category] with text or empty
    Column Y [FA Posting Type] with text or empty
    Column AC[FA Entry Type] with text "Fixed Assets" or empty

    The formula I need is:
    =IF(X2="Disposal";IF(Y2="Invoice";X2;"Liquidation");Y2)

    I want VBA to insert that formula in all rows where column AC [FA Entry type]="Fixed Assets" (or alternatively add one more condition i.e. if(AC="Fixed Assets";below formula;"")

    I tried using this one but it doesnt work.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 08-16-2019 at 01:55 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,595

    Re: Insert new column with a Formula

    Welcom to the forum,

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

  3. #3
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,224

    Re: Insert new column with a Formula

    Please Login or Register  to view this content.
    You might need to change all of the semi-colons in the formula to commas, I have UK Excel which uses commas, so I don't know if VBA is US based for that particular situation. Try it and see.

  4. #4
    Registered User
    Join Date
    08-16-2019
    Location
    Alicante
    MS-Off Ver
    MS 2019
    Posts
    6

    Re: Insert new column with a Formula

    thanks for the replies.

+ 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. Auto insert formula value when changes in column
    By jp16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2019, 12:16 AM
  2. [SOLVED] Formula to insert number in one column when an item is introduced in another column
    By Onditi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-07-2017, 05:03 AM
  3. Delete column and insert column n formula automatically
    By rb27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2016, 11:29 PM
  4. Replies: 5
    Last Post: 03-18-2015, 10:14 AM
  5. To Find and Insert column and add Formula and copy formula down
    By Akatecho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2014, 11:52 PM
  6. To insert column and add formula
    By Akatecho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2014, 01:25 AM
  7. [SOLVED] Formula to Insert the No 1 in column b when a number is detected in Column A
    By leinster93 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2012, 11:21 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