How to create a packing list from a distribution list

**Night Worker** · 02-18-2013, 06:07 AM

Hi folks,

I have a sheet (sample attachd here) which contains data as following:

D1:K1 Names of books to be distributed to colleges
B2:B10 Names of colleges who will receive books
C2:C10 Codes for Colleges
E2:K10 Number each book that a college will receive.

How can I create packing lists from this data? I will input College Code in a cell and all book titles and their quantities need to be filled up in the sheet.

There will be one packing list per college.

Is it also possible to create separate sheets for each college? Further can the new sheets be named according to College Code, for example 102?

Any help in formula/functions/vb code will be appreciated.

Regards

**JBeaucaire** · 02-18-2013, 11:39 AM

Can you add a sample PACKING LIST sheet that shows the actual layout you need for one of the colleges?

Also, each college code will only appear once in column C, correct?

**Night Worker** · 02-18-2013, 02:41 PM

Originally Posted by JBeaucaire

Can you add a sample PACKING LIST sheet that shows the actual layout you need for one of the colleges?

I have attached a sheet, made on the fly - as I don't have access to the original format right now.

Originally Posted by JBeaucaire

Also, each college code will only appear once in column C, correct?

Yes. Each college appears only once. One more thing: If a book has a 0 quantity for a college, it will be skipped.

Thanks

**JBeaucaire** · 02-18-2013, 04:12 PM

This is a "formula" based method, no VBA. There's a template sheet included. All you need do is copy the template sheet and change the name to the "code" you want for that sheet. The new sheet will immediately collect all the data for that school. Sheet 102 was already added to demonstrate.

**Night Worker** · 02-20-2013, 01:36 AM

Thank you for your help. It gave me a good start. Actually there is more that has to be done. I will try on my own. If I get stuck, I hope you will be there to help out.

**JBeaucaire** · 02-20-2013, 11:35 AM

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

Other issues should be new threads to garner faster responses.