+ Reply to Thread
Results 1 to 5 of 5

Need vba code to get row lines from master through A and C col key code segment wise

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Need vba code to get row lines from master through A and C col key code segment wise

    Dear experts

    I have keycode combination on debit A and credit C side in working sheet in E:E types of segment transfer to keycode.

    i want copy key codes from mastersheet to different segment through debit and credit keys values

    if the account segment is 6 keywords on bothside so 6 row lines copy from master sheet O:O paste to under Business Closed Calls for Account Source
    if the Currency segment is 12 keywords on bothside so 12 row lines copy from master sheet O:O paste to under Business Closed Calls for Currency Source
    like that till end of segment value

    find the attachment
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: Need vba code to get row lines from master through A and C col key code segment wise

    any experts help on my thread?

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need vba code to get row lines from master through A and C col key code segment wise

    Not sure to get it right:
    You want to pickup data from sheet "Master" an group these data in sheet "Expectresult" according to the keycode
    How to determine the type from the keycode to group data together?
    - Battle without fear gives no glory - Just try

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need vba code to get row lines from master through A and C col key code segment wise

    Try next code
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: Need vba code to get row lines from master through A and C col key code segment wise

    Thanks Expert working amazing!! Solved

+ 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. I need to add a verify segment to this code
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2016, 09:53 AM
  2. [SOLVED] Represent (define?) a section of code with a variable (shorten long code lines)?
    By Gene@action in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2016, 03:59 PM
  3. Generate Report Code Wise..
    By kundanlal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2015, 09:09 AM
  4. vba code for automating branch wise day wise amount to summary file
    By pranithpm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 04:18 AM
  5. Excel code to represent data from row wise to column wise
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 03:45 AM
  6. breakpoint adds lines to code when I run the code
    By Erikje in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2013, 02:35 AM
  7. Replies: 4
    Last Post: 06-28-2012, 12:42 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