Excel Range Copy Macro

To achieve this in Excel, you can create a macro using VBA (Visual Basic for Applications). Here's a step-by-step guide:

1. Open the Excel workbook and press ALT + F11 to open the VBA editor.
2. Insert a new module by clicking on "Insert" -> "Module" in the VBA editor.
3. In the module, create a Sub procedure and give it a meaningful name.
4. Define a range variable for the source range and set it to the desired range in the source worksheet.
5. Define a range variable for the destination range and set it to the desired range in the destination worksheet.
6. Use a loop to iterate through each cell in the source range.
7. Check if the cell meets the specific criterion using an If statement.
8. If the criterion is met, copy the cell value or the entire cell using the Copy method, then paste it to the corresponding cell in the destination range using the Paste method.
9. Repeat steps 6-8 for each cell in the source range.
10. Close the VBA editor and run the macro by pressing ALT + F8 and selecting the macro name.

Example:

Sub CopyRangeBasedOnCriterion()
    Dim sourceRange As Range
    Dim destinationRange As Range
    Dim sourceCell As Range
    
    Set sourceRange = Worksheets("Sheet1").Range("A1:A10")
    Set destinationRange = Worksheets("Sheet2").Range("B1:B10")
    
    For Each sourceCell In sourceRange
        If sourceCell.Value = "Criterion" Then
            sourceCell.Copy
            destinationRange.Cells(sourceCell.Row, 1).PasteSpecial xlPasteValues
        End If
    Next sourceCell
End Sub

Make sure to replace "Sheet1" and "Sheet2" with the actual source and destination worksheet names, and adjust the range as needed.

Note: Macros can make significant changes to your workbook, so it's recommended to make a backup copy before running them. The steps provided here give a general overview, and you may need to adapt them to fit your specific requirements.