Results 1 to 2 of 2

Thread: VBA Code To Loop Cells In A Column One By One And Search In Another Sheet

  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    1
    Rep Power
    0

    VBA Code To Loop Cells In A Column One By One And Search In Another Sheet

    Hi Team,

    Could you please help me to loop the copy cells one by one in a column and search the same in the next sheet.
    EX: we have many checks in the column A with different numbers and we use to copy these check numbers one by one and search the same in the next sheet, if available than the copied check and related amount should be paste in other required column.

    I hereby request you goodselves to kindly help me with the code.

    Regards,
    Rahaman,

    EDIT: removed email address
    Last edited by Excel Fox; 06-12-2013 at 07:43 PM. Reason: Email Address will invite spams

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    is the amount in column B? And the check number in column A has to be searched in column A of the next sheet, or in the entire sheet?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  2. Replies: 6
    Last Post: 05-16-2013, 09:56 AM
  3. Search form on work sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 5
    Last Post: 01-15-2013, 11:46 AM
  4. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM
  5. Replies: 2
    Last Post: 11-17-2011, 07:49 PM

Posting Permissions

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