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...
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.