Hi Everyone, I'm creating a spreadsheet to help track work projects. Here's what I'm hoping to do: 1. Be able to sort by "Project Number" while keeping all the cells in white with it's grey header row. In the image attached, P10001 is out of order. I'd like for this and all the white cells under it to be moved to cell B18 The image is just an example, I may need to do this for a sheet with 50 out of order projects on it 2. Filter by "Customer", "Program" and/or "Engineer" while keeping all the white cells with the correct project. Here's a couple of examples for what I'd like: In the image attached, if I filtered by "CM" for customer, Rows 7-17 would still be showing, the ones below would not If I filtered by "Adam" for Engineer, Rows 7-17 and 28-40 would be showing, the others would not Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sort & Filter Help

Thread starter acook1312
Start date Nov 21, 2022

acook1312

New Member

Nov 21, 2022

Hi Everyone,

I'm creating a spreadsheet to help track work projects. Here's what I'm hoping to do:

1. Be able to sort by "Project Number" while keeping all the cells in white with it's grey header row.

In the image attached, P10001 is out of order. I'd like for this and all the white cells under it to be moved to cell B18
The image is just an example, I may need to do this for a sheet with 50 out of order projects on it

2. Filter by "Customer", "Program" and/or "Engineer" while keeping all the white cells with the correct project. Here's a couple of examples for what I'd like:

In the image attached, if I filtered by "CM" for customer, Rows 7-17 would still be showing, the ones below would not
If I filtered by "Adam" for Engineer, Rows 7-17 and 28-40 would be showing, the others would not

Thanks