Macro to Move Certain Rows to Another Worksheet in Excel Workbook

M

macpen

New Member
Joined
Mar 27, 2017
Messages
4
Hello,

I am trying to create a macro to move all rows containing "dunk -", "Other", and "pro" in the worksheet called "Detail" into another worksheet called "Specifics" starting on row 2 so I can keep the heading on the "Specifics" worksheet tab. Once the rows are moved out of "Detail" I would like them deleted from that worksheet tab. Can anyone please help me write this macro?

Thank you so much!!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
You must log in or register to reply here.

Similar threads

W
  • Question
VBA Script to Move a Row to a New Tab
Replies
0
Views
260
wangaa11
W
V
  • Question
Help Needed for a Macro to Transpose
Replies
6
Views
163
alansidman
A
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
300
Insurance Dave
I
E
  • Question
Macro to apply filter and move result to another worksheet
Replies
1
Views
178
mumps
mumps
M
  • Solved
Moving Table Row to Another Table Based on Condition
Replies
2
Views
322
MJaspering
M

Forum statistics

Threads
1,215,614
Messages
6,125,843
Members
449,266
Latest member
davinroach

Share this page

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
Back
Top