requesting a macro

RSEKAR

Board Regular
Joined
Oct 18, 2010
Messages
169
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,
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

RSEKAR

Board Regular
Joined
Oct 18, 2010
Messages
169
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

Board Regular
Joined
Oct 18, 2010
Messages
169
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,839
Members
413,943
Latest member
Dhornsby21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top