Search for "copied" data

[cooper1308]

This is the code I have

Range("O48").Copy
    Sheets("Alerts vs Actual").Select
    Cells.Find(What:="x008", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate

Instead of looking for "x008", I need the macro to search for the copied data from cell "O48"....As it will always be a different value

[royUK]

How would Excel know that the data is copied?

[cooper1308]

How would Excel know that the data is copied?

"Range("O48").Copy"

Then I just CTRL+V'd it into the search field when I was recording the macro....But that obviously doesn't work, as it doesn't record the paste method rather just the value that was input....unless I can somehow code it to paste selection in the Cells.Find(What:="selection.paste"

Or something like that

Alternatively if we can make it search for the contents of the current selected cell in the next worksheet that would work also.....

[royUK]

Are you trying to copy a value to the next empty cell?

[cooper1308]

Are you trying to copy a value to the next empty cell?

Nope...

I'm selecting a cell...

Then offsetting by 9 columns...and copying the contents of the "trade ID" cell

Then searching the next worksheet for that same "trade ID" and selecting that cell

The term that I am searching for will always be relative to the initial cell I selected, and always have a different value

I guess I don't really need to copy it.....Just search for it on the next worksheet

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[cooper1308]

In the attached, please select B:48 on the "running PL" sheet

Then run the "CloseTrades" Macro...or hit the close button

Don't regurgitate when you see my code....it's a little messy

But as you can see I am looking to find the unique "trade ID" that is assigned on the next sheet. Obviously there will be far more data in time