Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,425
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Copy items based on certain criteria

    I have tried to write code to copy data from sheet creditors where "QRY" appears in Col Q and the value in Col V <> 0 to sheet "Query items" to Col AQ8 onwards

    Where the above criteria exists then the data must be copied from A5 to the last row in Col V , where "QRY" appears in Col Q and Col V <> 0

    when running my code, no data is pasted in Col AQ8 on sheet "Query Items"


    –see my code ‘Sub Copy_Queries_QRY()”


    I have manually copied the data to show you what it should look like after running the macro.


    It would be appreciated if someone could kindly assist me


    I also posted today on http://www.ozgrid.com/forum/showthre...216#post780216

    Regards
    Attached Files Attached Files
    Last edited by HowardC; 2016-10-29 at 11:38.

  2. #2
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,425
    Thanks
    126
    Thanked 5 Times in 5 Posts

Posting Permissions

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