Results 1 to 15 of 15

Need to convert one formula into code and add it to the existing code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-25-2021
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    2,171

    Need to convert one formula into code and add it to the existing code

    Hello code experts
    I need your help to add at the end of this code a formula which is to be converted into a code to get the final result. When I run the code, a new sheet is created with the Name of "GSTIN Verified.". I want to include in the code, to add this formula to get the combined values of J K L M and N in column P with the same code.
    =TRIM(SUBSTITUTE(J2&" "&K2&" "&L2&" "&M2&" "&N2,"0",""))
    If you convert the formula and get it in the second row below the heading, then resize the column P with column B and fill down.
    To test the code for the second time, delete the GSTIN Verified sheet and then run the code.
    Expected result sheet attached.
    Attached Files Attached Files
    Last edited by RAJESH SHAH; 10-03-2022 at 01:49 AM. Reason: #Solved by rollis13

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] assistance to modify vba code existing code sheets name to sheet tab names in filtering
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2018, 03:58 AM
  2. [help with code] need to update existing code to copy and keep rows on input page
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2016, 01:36 PM
  3. [SOLVED] VBA code in existing code to open when workbook encrypt with password.
    By deo_y in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2014, 07:08 AM
  4. [SOLVED] VBA code to save current worksheet as temporary PDF file and then add to my existing code
    By brianfromla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 08:35 AM
  5. Replies: 2
    Last Post: 12-17-2013, 11:51 AM
  6. Replies: 2
    Last Post: 03-17-2011, 08:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1