+ Reply to Thread
Results 1 to 8 of 8

Need VBA code to fill header values and drag formula till end of last row on target column

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Need VBA code to fill header values and drag formula till end of last row on target column

    Hi experts

    i have set of data need to find brand on F:F values

    if column values end with (Y) or (Y1) its NT-BDEALER
    rest of all data Non NT-BDEALER

    and last 3 columns(V,W,X) from U col,Need to fill with V= Date,W=Name,X=ISIN Code. and fill formula down till end of row.
    V col
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    W col
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    x col
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    find the attachment expected sheet is my requirement
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,004

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    in G2

    =IFERROR(IF(FIND("Y",F2),"NT-DELEAR"),"NOT NT-DEALER")

    in W2

    =IFERROR(VLOOKUP(J2,vlookup!A:B,2,0),"")
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    Brah Can u help me with VBA Code?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    Thanks Boss !!! Solved Thanks for your time

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    I only took over where John left off...Glad to have contributed...Tx for rep +

  7. #7
    Forum Contributor
    Join Date
    08-27-2015
    Location
    Singapore
    MS-Off Ver
    Office 2010, Office 365
    Posts
    158

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    I just drop by and saw this. I've notice there's some typo and mismatch in john formula. Since most search feature are case sensitive, text like CAMPBELL SOUP COMPANY may not be detected by the search/find feature. Maybe you can try using this as formula.
    Please Login or Register  to view this content.
    Or this formula if you have a fixed search text range containing (Y) or (Y1) which in my case is K2:K3
    Please Login or Register  to view this content.
    Final VBA code with thanks to sintek
    Please Login or Register  to view this content.
    Last edited by seercoven; 10-19-2022 at 05:33 AM.

  8. #8
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: Need VBA code to fill header values and drag formula till end of last row on target co

    Thanks Boss, great help!! Solved @Seecoven and @sintex.

+ 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. need vba code to fill formula where cursor start till end of result in header value
    By MicroTees in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2021, 12:03 PM
  2. [SOLVED] VBA to fill formula down till last row in column.
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-12-2018, 04:27 PM
  3. [SOLVED] VBA to fill formula down till last row in column
    By Wither125 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2016, 06:03 PM
  4. How to drag the formula till the end of the data in previous column
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2015, 03:04 AM
  5. [SOLVED] vba to fill values till end of text values in B:B column.
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2014, 03:06 AM
  6. vba help to delete the column till values met desired header
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2014, 07:32 AM
  7. [SOLVED] Identify the last filled row in Column A and then drag formula in Column B till the same
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2012, 10:50 AM

Tags for this Thread

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