Table - lost rows. Too many tables on worksheet?

[MattG]

Hi Guys,

I work in a contracting company that supplies things. I made a big workbook with a worksheet that has multiple tables. I am thinking that may have been a less than ideal approach but open to suggestions. The main reason for having all on one is across the top I have "positions" so on a project I can just populate the number of pieces of equipment we need for each position and have it sum in a column on the left.

The issue I keep running into is I look a the job, I populate the main area with counts. I then want to filter out any rows in each table that are "Blank". I do that, in this example I go to item type on row 99. I filter and get unintended results. Then I select a filter to check mark "Select All" thinking I should see all rows. But some rows are still hidden. Say in this example 215, 217-231, etc.

Is this an operator error? Would there be a better approach to doing this? Basically I ideally want one big sheet I can layout columns of different positions/locations and populate the items needed. Each table is a "category" of items. Honestly I'd probably like to add 2-3 more table on the same sheet. I then want to be able to filter out all rows in each table that do not have any values in them to more easily see what is needed on a given job.

I thought this was a good/correct approach but it keeps giving me odd results and I find rows with values are missing or vice versa.

Any help is appreciated.

Thanks
Matt

[Glenn Kennedy]

Hi. Before we get going on this one...

Is your forum profile showing the Excel PRODUCT that you need this request to work with?

The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

Cheers,

Glenn.

[MattG]

I just added to my profile, but for reference.

MS365 - V2211

[Glenn Kennedy]

I'm not entirely sure if I understand you...

But, I wouldn't structure it the way you have. One big flat boring table is soooo easy to work with.

Would the sort of layout on sheet 1 work?

[MattG]

Trying to keep the "categories" if you will. Various items go to different department and are very different things.

For a easy example think of building a house. One section is wood or lumber, one is plumbing, one is electrical. I want to keep those separate with a table for each if possible to more easily separate each by department. One table would be arguably more confusing.

[HansDouwe]

But some rows are still hidden. Say in this example 215, 217-231, etc.

The reason: There is still a manufractor filter active in cell AJ99.

[MattG]

Would like to insert a "Facepalm" emoji in here if possible!!!!!

[HansDouwe]

This one? It is not nesessary

[MattG]

Ha thanks, no totally warranted.

Yeah have one section of "lighting fixtures" that I built out as concat rows. Idea being I could filter if needing to fit a certain wattage, or something like that. Whomp whomp

[Glenn Kennedy]

OK, so. Get rid of the blanks from column C

Now you can filter MUCH more easily.

If/when you add more rows, add them at the bottom and sort by col B then by Col c.

[MattG]

Yep, that was kind of my "mid-process" at the moment when I posted this. It is a little slow here so trying to add new items now and noticed something funky but didn't realize it was so much of an operator error.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[HansDouwe]

You are welcome, glad to have helped and thanks for the rep .