+ Reply to Thread
Results 1 to 3 of 3

Help with Macro to Move Data to Another Worksheet

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    London, ON
    MS-Off Ver
    Office 2010
    Posts
    64

    Help with Macro to Move Data to Another Worksheet

    I have an inventory printout from Quickbooks that lists every part that has ever been around. I have many items that have 0 for a Qty. I'd like to have a macro that could look at a cell and if the value is 0, move that entire row to a new workbook inside the same spreadsheet. I've made a sample test file and attached.

    Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Help with Macro to Move Data to Another Worksheet

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-13-2015
    Location
    London, ON
    MS-Off Ver
    Office 2010
    Posts
    64

    Thumbs up Re: Help with Macro to Move Data to Another Worksheet

    I love this site! Many great people like yourself that provide fast answers to questions.

    Many thanks works as I need it! :D

+ 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] Macro to move data from one worksheet to another based off of criteria;
    By KLiving in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2015, 12:41 PM
  2. [SOLVED] IF data on opened worksheet has blank data then cancel macro and move onto next part
    By jonathan.haynes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2013, 07:11 AM
  3. Need Macro to move data from one worksheet to another
    By sugarweasel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2013, 03:50 PM
  4. [SOLVED] Macro in excel to move a row of data from one worksheet to another worksheet
    By wmdowty in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-26-2013, 11:06 AM
  5. [SOLVED] Move data to another worksheet and automatically run macro.
    By ghoshl1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2012, 02:16 PM
  6. Replies: 5
    Last Post: 02-27-2012, 10:17 AM
  7. Macro to move data into a seperate worksheet in order
    By Vikkyann in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2007, 04:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1