Dec 03 2018 02:12 PM
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 them in packages, for instance "dual monitor cpu setup". Each package would include multiple items that will later need to be purchased individually, but to having the working list shorter, there would be less margin for errors.
I was imagining putting all the packages on one tab, then referring to them package name on a second tab (the working list), then a third tab would look at tab 2 and break all the packages out into individual items automatically. It would aslo transfer over any individual items. That would be the purchase sheet.
Is this possible? Thanks for your help.
Dec 04 2018 02:36 AM
Dec 04 2018 08:36 AM
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.
Dec 04 2018 08:50 AM