+ Reply to Thread
Results 1 to 7 of 7

Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

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

    Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    Dear sir

    dear experts i need vba code to cut and paste only value of tollcharge avoid zero and blank
    I want cut data from master paste into new sheet with rename of the sheet

    I have set of transport data which includes toll free charges... i want cut and move particularly tollcharges value from column H:H
    where find values those charge move to newsheet with rename of "Tollcharge"

    find the attachment
    Attached Files Attached Files
    Last edited by johnlara; 04-19-2015 at 03:06 AM. Reason: explain

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    You can watch the replies for this thread. It is identical to yours (even the example data).

    http://www.excelforum.com/excel-prog...a-col-vba.html
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

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

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    any experts help on this?

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    What have YOU tried so far?

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    this should do it

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,552

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    Please Login or Register  to view this content.

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

    Re: Vba to extract Toll Charge from H:H column in Master and paste into newsht with rename

    yes sir I tried i quiet new to vba excel that why i struck to learn soon i will good code writer thanks alot time spend on my thread and 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. [SOLVED] Cut data from master and paste into next newsheet depends upon value of a col vba
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-21-2015, 12:36 PM
  2. [SOLVED] Range.Cut Paste on NewSheet
    By dlow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2015, 03:10 PM
  3. Copy Data between 2 dates and paste it newsheet
    By Knowledge is Wealth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2013, 09:57 AM
  4. Data Move to Master from sheet1,sheet2 vba depends upon column heading value
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2013, 03:21 AM
  5. Replies: 5
    Last Post: 09-19-2008, 04:02 PM

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