Consulting

Results 1 to 5 of 5

Thread: Copy and paste in one worksheet by conditionqq

  1. #1

    Copy and paste in one worksheet by conditionqq

    Hi
    In one worksheet i have a table with 3 column ABC column A is text that fill manualy B is number fill with vlookup and C is percentage of column B so beacuse of some row column B is zero i need to export a new table in column E to G that only show the row of previous table that column B is greater than zero to define a series by offset and count to draw a pie chart
    So i need a VBA to copy and paste rows that have value in column B greater than zero in column E To G

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,572
    A sample workbook please…
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    sample has been attached
    Attached Files Attached Files

  4. #4
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,572
    Perhaps filter the table. See attached.
    Attached Files Attached Files
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  5. #5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •