+ Reply to Thread
Results 1 to 4 of 4

copy cells data from 1 sheet to another

  1. #1
    Registered User
    Join Date
    05-02-2014
    Location
    dong nai, Vietnam
    MS-Off Ver
    Excel 2013
    Posts
    15

    copy cells data from 1 sheet to another

    Hello everyone.

    i am stuck with the vba copy the value to another sheet. the VBA stuck at value = 0

    i need to fill at least 5000 lines that is not = 0

    i fixed the value 0. However, the copy does not goes as i want.
    i just want to copy the row with value and omit the 0 value - row.

    As i post the example

    can someone please help me to solve the problem
    thank you very much
    Attached Files Attached Files
    Last edited by vho; 03-24-2017 at 07:13 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: copy cells data from 1 sheet to another

    Here is one way,
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: copy cells data from 1 sheet to another

    Also another way,

    Provides for unlimited Rows, and a Reset Button;

    Please Login or Register  to view this content.
    Try attachment.


    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: copy cells data from 1 sheet to another

    Hello vho,

    Thank you for adding to my Reputation, I appreciate it!

    Glad I could help somehow.

    Kind regards.

+ 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. Simply Copy and pasting data from one sheet to another sheet but certain cells....
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2014, 09:36 AM
  2. [SOLVED] Copy data from one sheet (multiple cells) to another sheet in tabular form
    By dvs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2014, 12:13 PM
  3. Copy the data in any active row in Sheet 1 to specific cells in Sheet 6
    By cti4sw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 02:43 PM
  4. Replies: 0
    Last Post: 09-22-2012, 03:38 AM
  5. Copy data from a sheet and Paste in another sheet into Merged cells
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2011, 02:01 PM
  6. Copy data from one sheet (Fixed Cells and sheet) to another sheet
    By RCatman23 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-21-2009, 12:56 PM
  7. Need macro to copy data from sheet 1 to multiple pages on sheet 2 in correct cells
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-16-2009, 03:33 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