Results 1 to 5 of 5

Copy to another sheet based on the value

Threaded View

kav4 Copy to another sheet based... 10-06-2014, 01:13 AM
Kamboj Re: Copy to another sheet... 10-06-2014, 04:07 AM
kav4 Re: Copy to another sheet... 10-06-2014, 05:05 AM
Kamboj Re: Copy to another sheet... 10-06-2014, 06:58 AM
kav4 Re: Copy to another sheet... 10-06-2014, 07:02 AM
  1. #1
    Registered User
    Join Date
    10-05-2014
    Location
    Sri Lanka
    MS-Off Ver
    2007
    Posts
    5

    Copy to another sheet based on the value

    Hi,

    I have a workbook with 2 sheets. In 1st sheet there are some data with 6 columns.

    I want the entire row to copy to the 2nd sheet if the value of the 5th column of the particular row is equal to "0".

    I need to save this second sheet as a .csv file to import it to my accountancy software. If I apply filters to the first page, when I saving the sheet as a csv file, it still shows the hidden unwanted rows as well.

    Thanks in advance for your help.
    Last edited by JBeaucaire; 10-06-2014 at 02:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  2. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  3. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  4. [SOLVED] Macro: Dynamic creation of sheet based on cell value then copy range to the new sheet
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-15-2012, 11:31 AM
  5. Need Macro to search from mater sheet and copy in another sheet based on Criteria
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-29-2012, 01:03 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