+ Reply to Thread
Results 1 to 5 of 5

Macro to INSERT a column and calculate based on preceding columns.

  1. 09-11-2017, 03:37 AM #1
    acsishere
    acsishere is offline
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    582

    Macro to INSERT a column and calculate based on preceding columns.

    Dear Friends,

    I need a macro to that INSERTs a column and calcuates the values based on preceding columns and get the result in the inserted sheet.

    I have attached the sample Excel file in which I have mentioned the requirement in detail.

    Request your kind support, please.
    Attached Files Attached Files
    Good friends are hard to find, harder to leave, and impossible to forget.

    acsishere.
    Reply With QuoteRegister To Reply
  2. 09-11-2017, 03:51 AM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Macro to INSERT a column and calculate based on preceding columns.

    hi acsishere. try
    Please Login or Register  to view this content.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
  3. 09-11-2017, 07:37 AM #3
    acsishere
    acsishere is offline
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    582

    Re: Macro to INSERT a column and calculate based on preceding columns.

    Thanks a lot for this code.
    And I would like to do "SUM" also for the columns C to F (sum of each column at the bottom of the last row where the value is there).

    Please help me.
    Reply With QuoteRegister To Reply
  4. 09-11-2017, 08:17 AM #4
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Macro to INSERT a column and calculate based on preceding columns.

    add this line below:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 09-11-2017, 08:32 AM #5
    acsishere
    acsishere is offline
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    582

    Re: Macro to INSERT a column and calculate based on preceding columns.

    Thanks a lot Sir.... Great...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional formatting based on preceding cell in a series of columns
    By [email protected] in forum Excel General
    Replies: 6
    Last Post: 03-22-2015, 10:34 AM
  2. Calculate values in two columns based on a value in a third column
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 10:05 AM
  3. [SOLVED] Conditional format cells in column, RAG, based on preceding cell value
    By Smudge.Smith in forum Excel General
    Replies: 8
    Last Post: 11-08-2013, 05:21 AM
  4. [SOLVED] Formula to insert text in new column if preceding more than one of the preceding have val
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 11:47 PM
  5. Need to calculate the average for a column, based on values in two other columns
    By mattr86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2012, 11:26 AM
  6. [SOLVED] Macro to add data to preceding column based on collumn data
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2012, 01:27 PM
  7. Sum alternate columns based on preceding columns
    By Gallinski in forum Excel General
    Replies: 2
    Last Post: 11-10-2011, 05:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1