VBA Move Rows Based on Criteria

G

gmcgrane

New Member
Joined
Jul 12, 2012
Messages
24
Hi Guys,
Im looking to use a macro to move rows from Active to sheet Returned based on the drop down menu wording in Row M.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
I wont be solving this but you need to explain more.

Where on sheet Returned? Top of sheet? Bottom of sheet? Somewhere in the middle? Where in the middle?

"Based on the drop down menu"
What does that mean...specifically?
 
Upvote 0
Thanks for feedback,

The data should be moved from "Active" sheet to "Returned" sheet at the top of the sheet, as there will be multiple entries being moved to "Returned" data should be entered in blank cells only.
The drop down menu has contains the wording: Forgot, Returned, Stolen should this information be selected move row.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Automatically Move Row to Another Sheet Based On Cell Value
Replies
1
Views
879
kevin9999
K
M
  • Question
Auto Sort rows based on a selection from a drop down menu
Replies
4
Views
140
Joe4
Joe4
N
  • Solved
VBA to insert rows in sheet 2 (parts list) at row 5,& move existing datas down while inserting new rows,when drop down value is selected on E4 sheet1.
Replies
8
Views
379
nscaria00
N
M
  • Question
Hide Rows based on cell with drop down values
Replies
1
Views
581
kevin9999
K
V
  • Solved
VBA Cut rows and paste values
Replies
3
Views
216
dreid1011
dreid1011

Forum statistics

Threads
1,216,209
Messages
6,129,517
Members
449,515
Latest member
lukaderanged

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