+ Reply to Thread
Results 1 to 2 of 2

VBA code for copy visible data and paste in another sheet

  1. #1
    Registered User
    Join Date
    10-11-2015
    Location
    india
    MS-Off Ver
    2010
    Posts
    6

    VBA code for copy visible data and paste in another sheet

    Hi All,
    Need VBA code for copy visible data and paste in another sheet
    There are two sheets
    1.data
    2.Results
    data sheet has data in 5 columns (A, B, C, D, E) and rows are more than 50000. I applied filters randomly
    now i want copy only A,B, E rows and paste in results
    you can download sample data here: https://drive.google.com/file/d/0B6f...ew?usp=sharing
    Kindly help me.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: VBA code for copy visible data and paste in another sheet

    Please use the forum upload program to make spreadsheets available.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. vba to copy a picture from a hidden sheet and paste in visible sheet?
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-30-2015, 10:21 AM
  2. VBA code to put a pivot and copy paste the data on a other sheet
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2013, 12:07 PM
  3. [SOLVED] Copy range from one sheet and paste in another sheet on the next visible row after header
    By MaQian in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2013, 10:48 AM
  4. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  5. Vba code to copy and paste second visible cell to other worksheet range then the next
    By Justin25150 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 09:03 AM
  6. Copy and paste visible to different sheet
    By cabinetguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2011, 03:04 PM
  7. Copy paste visible on same sheet
    By Jay in forum Excel General
    Replies: 1
    Last Post: 09-26-2005, 12:05 PM

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