Forum Discussion
Nesting equipment groups in excel
Hello! I am new to the deeper levels of Excel and I am trying to solve a problem at work. We have equipment lists thousand of lines long. These lists could be easier to manage if we could put the...
If you add "Package name" as a column to your current table of items you can filter the table for "Package name", possibly by adding a slicer for that column. Then after applying to filter you can easily copy the visible rows to anywhere else.
Yes I can see how that would help. But if we could prevent staff from having to enter every item individually, that would cut down on human error. I think I can do the short list and then use a count formula to add numbers to the purchasing tab that would include the individual items.. something that came to me in my sleep.
- I think you'd need some VBA routines that help with copying filtered items elsewhere.