+ Reply to Thread
Results 1 to 4 of 4

VBA code to copy which are greater than 1 paste to new sheet with len key 30 only

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

    VBA code to copy which are greater than 1 paste to new sheet with len key 30 only

    Dear expert

    I have data with currencies values & auto key values i want copy amount values greater than 1 in H:H column then towards C column and In A column where ever len is 30 which is key id those two values need to copy to new sheet.

    once copy to new sheet re-name sheet as FY'16

    please find the attachment.
    Attached Files Attached Files

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: VBA code to copy which are greater than 1 paste to new sheet with len key 30 only

    Please Login or Register  to view this content.
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: VBA code to copy which are greater than 1 paste to new sheet with len key 30 only

    Hi Johnlara,

    I have ammended kalbasiatka's code to copy the values to a new sheet named FY'16 as requested.

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

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

    Re: VBA code to copy which are greater than 1 paste to new sheet with len key 30 only

    Thanks for great help sir It works!!

+ 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 Copy and Paste in different sheet
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-09-2015, 03:09 PM
  2. [SOLVED] Copy and paste a row into a separate sheet if a column's value is greater than 0.
    By ladybug1216 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2015, 09:54 AM
  3. VBA Code to Copy entire sheet and paste in another sheet
    By molly13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 11:45 AM
  4. VBA code to search from different sheet > Copy the row > Paste on different sheet.
    By qpywsqp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2013, 11:13 AM
  5. [SOLVED] VBA code to copy and paste an entire row from one sheet to another
    By emach in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-24-2013, 12:12 PM
  6. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  7. Sheet code to copy & paste a new row of Info to another sheet
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 05:31 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