Copy Cell Data to another sheet based on Cell Condition

Hello All,
Request for guidance from the VBA Experts.

I am having data in cells AS7 to AS7 of Sheet1.
If AS7 is not blank, then corresponding cell in Column AT7 will show the status as "UPDATED"

I want to create a macro with the following conditions:

If AT7 = "UPDATED", then
Copy AS7 from Sheet1 and paste the same to D7 of Sheet2.

Please help.

Thanks Mumps1. It works perfectly. Thanks again for the quick help.

Hi Mumps1...even though your earlier solution worked perfectly, the same is not happenning when I give a range.
Attached herewith the sample file with two sheets.

If Col 'K' (any row) of "Stock Report" sheet is having the word "E COA", then, I want the data of different
cells of that particular row to be copied to respective cells of Col 'D' of sheet "E COA". Similarly, if next
row of Col 'K' of "Stock Report" sheet is having the word "E COA", then the data to be copied to respective
cells of Col 'E" of sheet "E COA". Same for next row.

Can you please help me out.

Please don't think that I am simple asking for the help without putting any efforts. I could have done some
R&Ds at my end too...however, I am unable to put my ideas in VBA mode. Please help.

Thanks Mumps1 and Good Morning.

Attached herewith the sample file.

Sheet "Stock Report"
What I have done : Using "IF" function, (if Columns "A" to "I" is not blank and if Column "J" is having "E", Column "K" will show as "E COA"
Using "IF" function, (if Columns "A" to "I" is not blank and if Column "J" is having "D", Column "K" will show as "D COA"

What I would like to do: Once Column "K" indicates "E COA", the I would like to copy the data to sheet "E COA". E.g. If "K7" shows "E COA", then I want the data to be copied from:
"E7" ("Stock Report" Sheet) to "D8" ("E COA" Sheet).
"F7" ("Stock Report" Sheet) to "D9" ("E COA" Sheet).
"G7" ("Stock Report" Sheet) to "D10" ("E COA" Sheet).
"H7" ("Stock Report" Sheet) to "D11" ("E COA" Sheet).
"I7" ("Stock Report" Sheet) to "D12" ("E COA" Sheet).

The above rule is applicable if any of the cells of Column K (it can be K12 or K15 or K100) is having "E COA" word.
If Col 'D' of "E COA" sheet is completely filled, then next row data of Stock Report Sheet should go to Column "E"
of "E COA" sheet.

Once Column "K" indicates "D COA", the I would like to copy the data to sheet "D COA". E.g. If "K7" shows "D COA",
then I want the data to be copied from:
"E7" ("Stock Report" Sheet) to "D8" ("D COA" Sheet).
"F7" ("Stock Report" Sheet) to "D9" ("D COA" Sheet).
"G7" ("Stock Report" Sheet) to "D10" ("D COA" Sheet).
"H7" ("Stock Report" Sheet) to "D11" ("D COA" Sheet).
"I7" ("Stock Report" Sheet) to "D12" ("D COA" Sheet).

The above rule is applicable if any of the cells of Column K (it can be K12 or K15 or K100) is having "E COA" word.
If Col 'D' of "D COA" sheet is completely filled, then next row data of Stock Report Sheet should go to Column "E"
of "D COA" sheet.

Wonderful Mumps1. Works perfectly. Thanks a lot. Unfortunately, I am unable
to add "reputation" (forum rules don't allow it). Really grateful to you. Thank
you again.