+ Reply to Thread
Results 1 to 9 of 9

VBA code for Add multiple Column cell Value in New Column Cell

  1. #1
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    VBA code for Add multiple Column cell Value in New Column Cell

    Hello Exprts
    We have a workbook with more then 1500 rows (in 3 column) numaric data
    We want add column Numaric Value to add (sum) in a new Column insted of sum forumla we want to see what value we add in this cell
    for eg..
    Column A = 5, Column B=2.65 Column C=6.35
    we want add these 3 value in a new column i.e. Column D where show this value like following when we press f2 on cell
    =5+2.65+6.35

    we attach a sample file pls help us to solve this problem..

    Thanks in Advance
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    I have read many questions and sometimes I am really surprised at the questions people can ask and why but you will have your own reasons for that
    If you want to see that then you will have to use vba to actually see the numbers which you will have to copy one by one.
    instead of
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    but then you still don't see the values only the cells similar as the SUM, so my guess is to write a macro that places the three values in the cell.
    You can do it simply by recording it or worksheet_Change event for that column to place the values in the new column
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    sir ur suggestion show cell value which one we add..

    but sir we want show number value.. insted of b2 c2 and d2... so that i want a vba ..

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    Then what you are really doing is entering the the same value again, I honestly do not understand why you would want that.
    And since you're asking, do YOU have any VBA knowledge and know how to work with macros?
    It will be useless f you cannot modify it yourself

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    Modify a value in column B, C or D

    Hope you understand it and can use it
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    sir exactaly i want this.. Firstly Thankyou so much for this valuable help
    but this is not show in a macro base.. which one i run with Atl+f8
    i think this is even base macro.. actually i have already data so that we want a macro which run with Alt+f8
    pls convert this code in a macro so that easily we apply in my original excel file..

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    I don't know which formula you run with Alf+F8 but you can add the syntax in the macro and you've got it

  8. #8
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    sir we want this code as a macro form..
    currently this is i think a event base code.. actually when we press alt+f8 then my macro window is black no macro is display there...

  9. #9
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: VBA code for Add multiple Column cell Value in New Column Cell

    Then I will need to know where you want the answer and the exact calculation you require
    You already have two macros in the VBA folders but they are very much incorrect

+ 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] VB Code to copy paste data from column to another column based on content of cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2019, 08:50 PM
  2. [SOLVED] Vba code to split multiple project in different cell in same column.
    By UPA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2018, 01:07 AM
  3. Merging Multiple Sheet's column of data based on other column's cell value
    By BALA1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2017, 12:32 AM
  4. [SOLVED] VBA code to fill a cell in a column based on another column
    By donhadriano in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2015, 07:51 AM
  5. Select part of a cell in a column to multiple by another column cell
    By dadirtypanda in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2014, 03:57 PM
  6. Replies: 3
    Last Post: 02-13-2013, 04:05 PM
  7. I need the code for hiding a column if a cell in that column has no date.
    By Martynoxon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 11:17 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