I have created this basic macro to copy data from one worksheet ("Search") to another ("Stocktake") and was wondering if anyone had advice on how to add code to get the macro to check if the values in column D ("Search") are already in column A ("Stocktake).
If they are the macro would stop and display a message "Asset already counted"
- Sub Macro27()
- ' Macro27 Macro
- ' Keyboard Shortcut: Ctrl+t
- Range(Selection, Selection.End(xlDown)).Select
- ActiveCell.Offset(1, 0).Range("A1").Select
- End Sub