+ Reply to Thread
Results 1 to 12 of 12

Copying the row datas to another sheet if a cell is negative

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202

    Copying the row datas to another sheet if a cell is negative

    Hello everyone,

    I have a file which I use for the payment collection for my office.
    There are totally 7 sheets as of now and it can be increased in future.
    The Columns A to H has the details of the customers and some calculations.
    The column I is the total column.

    Now I have a blank worksheet as "PENDING LIST"

    If the column I of sheet 1 is negative (less than 0) then I need to copy the values from A to I to the Pending list.
    Like this it should check for all the rows in all the sheets.

    Right now am using Filters to solve this but it takes too much of time.
    A macro will definitely save me lot of time.

    Somebody help me to solve this.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copying the row datas to another sheet if a cell is negative

    I could not imagine any code could be faster than a filter code, but I can not see any filter code.
    You have also merged cells on the pending sheet, like 100 B - 50,000
    Are these sheet names?

  3. #3
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Copying the row datas to another sheet if a cell is negative

    Hello AB33,

    Thanks for the reply.
    I have inserted filters and not the code for that.
    The cells can be unmerged. That's not a problem.

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copying the row datas to another sheet if a cell is negative

    You do not mentioned if you want to copy the last total row or not.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202
    Last total column can be omitted.

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copying the row datas to another sheet if a cell is negative

    A-I column and last row is omitted

  7. #7
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202
    Yes you are absolutely right.

  8. #8
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Copying the row datas to another sheet if a cell is negative

    The last "TOTAL" column in each sheet can be omitted. The Range is from A1:I16.

  9. #9
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copying the row datas to another sheet if a cell is negative

    Can be omitted?
    I have already told you it did.

  10. #10
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202
    Ya it can be omitted. Thats not a problem.

  11. #11
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Copying the row datas to another sheet if a cell is negative

    So, the code does as you want it. What is wrong with the code?

  12. #12
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202
    Actually now am sorting it out and copying the datas to the pending list. So on click of a button in pending list will this be done.?

+ 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] Need VBA code for copying datas from different sheets to one sheet
    By kesavanprabhu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2013, 05:42 PM
  2. compare oracle table datas and excel datas
    By james94539 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2013, 03:48 PM
  3. copying the datas along with the activex controls and pasting in another worksheet
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-14-2011, 01:30 PM
  4. sort certain datas in a wide range of datas
    By go4cdt in forum Excel General
    Replies: 2
    Last Post: 03-20-2006, 12:45 PM
  5. re : Finding the datas and deleting datas which are not found.
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2005, 09:05 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