Results 1 to 5 of 5

Search for cell equal to cell in another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2008
    Posts
    9

    Search for cell equal to cell in another worksheet

    Hi all,

    I'm trying to search for a cell in the Cardio Database worksheet that is equal to a specific cell in the Design Cardio worksheet (B3). Once it finds a match I want it to copy the range of cells below that "found" cell in the Cardio Database, and paste it in the Print 6Day worksheet (A4:I19). The search needs to look across row 1, then jump down to row 21, 41, 61, etc. if it does not find a matching cell.

    This is what I have so far:

    Sub SearchCardio()
    
    Application.ScreenUpdating = False
    Sheets("Cardio Database").Select
    Range("A1").Select
    
    Do Until ActiveCell.Value = ""
    If ActiveCell.Value = Sheets("Design Cardio").B3 Then
        ActiveCell.Select
        Exit Do
    ElseIf ActiveCell.Value <> Sheets("Design Cardio").B3 Then
        ActiveCell.Offset(0, 1).Select
    End If
    Loop
    
    End Sub
    Thanks for any help! I've attached a short version of the workbook to aid anyone that needs further explanation.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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