+ Reply to Thread
Results 1 to 4 of 4

VB Code to copy certain data

  1. 01-22-2019, 02:02 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to copy certain data

    Hello:

    Please refer to attached file.
    I need VB Code to copy data based on cell H1 and compare with that in column A
    I have manually copied for Feb18 as shown
    Please let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-22-2019, 02:27 PM #2
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: VB Code to copy certain data

    Hi Riz,

    If it is allowed to add one cell to your data (in this case shift cell H1 down to cell H2, and add cell H1 data), then this is dead easy using Advanced Filter.
    Please see my attached file.

    Code on Sheet1 module :
    Please Login or Register  to view this content.
    You just need to change the dropdown value on cell H2.
    Attached Files Attached Files
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 01-22-2019, 02:37 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to copy certain data

    Hello karedog:

    Excellent logic and idea.
    Thanks

    Riz
    Reply With QuoteRegister To Reply
  4. 01-22-2019, 02:40 PM #4
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: VB Code to copy certain data

    You are welcome Riz, thanks for marking the thread as solved and rep.points.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code to copy data does not copy last row in source data
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2018, 05:09 AM
  2. [SOLVED] VB Code to copy certain data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2016, 12:29 PM
  3. [SOLVED] VB Code to copy certain data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2016, 04:08 PM
  4. VBA code to make of copy of workbook2 and then copy data in that from Workbook1
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2015, 06:34 AM
  5. vba code to determine last row containing data and copy the data to another sheet
    By Buddy8 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-08-2014, 07:35 AM
  6. VBA code to copy data from Excel data table to user form
    By Srikanth H N in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2014, 11:53 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1