returning data to another tab

[mlance617]

hello

I have data on one tab in a workbook titled "1804", on this tab I have multiple rows that in column "B" have the contents "RM". I need specific data for each row moved to another tab in the workbook titled "RM". On the RM tab I need the following cells content moved from the "1804" tab:

column C contents, moved to column A (starts at cell A2) on "RM" tab

column K contents, moved to column B on "RM" tab

column M contents, moved to column C on "RM" tab

Column N contents, moved to column D on "RM" tab


EDIT:
either a macro script, or formula I can paste in on each row of the RM tab. but each row needs each individuals row data (theres a lot)

 

[Micron]

I wouldn't call myself an Excel power user, so this may be a dumb question:
Why don't you just click on the non-contiguous column headers to select all the rows in those columns, then choose the top left cell where you want the results to go and paste. Then go back to the source sheet, right click on one of the still highlighted columns and choose clear contents? Done. It should work because the columns in your destination sheet are contiguous.

 

[mlance617]

just trying to eliminate the copy paste. there are a lot of other rows id like to apply a similar formula