How to move a row of data based on criteria

DeMetsFan

New Member
Joined
Sep 13, 2024
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Hello,
I am new to macros and coding and would love some help trying to make this work.

I have a workbook that we use for training new managers. Our market is split into an east and west section.

I would like to move the data from this worksheet named Full Roster, to a new worksheet named East if the criteria in column I is East and to a worksheet named West if the criteria is West.

Screen Shot 2024-09-13 at 4.57.35 PM.png


Any help that can be offered would be amazingly appreciated.

Please let me know if I did not explain well enough.

Thanks
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
In West sheet in A2
Excel Formula:
=FILTER('Full Roaster'!A2:I200,'Full Roaster'!I2:I200="West")
Similarly for East sheet you can use formula by changing as East.
 
Upvote 0

Forum statistics

Threads
1,224,568
Messages
6,179,591
Members
452,927
Latest member
whitfieldcraig

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