requesting a macro

[RSEKAR]

Dear Sir,
I am in need of a macro to satisfy the following requirements.
I have two sheets in my work book named as “SELL” and “SELL1”.
I copy some of the data from the SELL sheet and paste (as paste special - values) in the SELL1 sheet.
The SELL sheet is filtered on some criteria. The SELL1 sheet is not filtered.
In SELL sheet the filtering starts from 10<SUP>th</SUP> row
Pasting should be done in the SELL1 sheet starting from 10<SUP>th</SUP> row.
From the SELL sheet B, G, AT, AJ column data should be copied and pasted to A B, C, D columns of SELL1 sheet. In SELL sheet some of the rows contain the text “Sell” in M column. On filtering the rows which contain the text “Sell” (in M column) will be placed in the top rows.
The rows which contain the “Sell” (in M column) the data are to be copied from the B, G, AT, AJ columns and the data to be pasted to A B, C, D column of SELL1 sheet (paste special values).
Thanking you in advance,

 

[mikerickson]

You can get that from the Macro Recorder.

 

[RSEKAR]

Sorry, I am new to EXCEL and leaner in macro. Yes I do record macros using macro recorder.
I have not recorded the macro with a condition. The rows which contain the text “Sell” in M column, the different columns to be copied and pasted to another sheet. I use Excel 2002 and XP.

 

[RSEKAR]

Dear Sir,
As you have suggested, I have tried myself with the macro recorder available in the excel file. I have achieved the goal and recorded the macro. It is working well.
Thanking you for your suggestion.

 

[mikerickson]

I'm glad it worked for you.