you can use this excell sheet which i use it in my work.
here are some notes:
1- Arrange all parts according to:
a) RefDes.
b) Value.
2- You chose the color of any cell according to the Manufacturer.
You can use Excel to generate part numbers, create bills of material and cost them including quantity price breaks using lookup tables and generate purchase orders.
You can use conditional formatting to automatically change cell colours according to different constraints. All of this kind of approach is covered in my book (plus lots more)
Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers
published by Elsevier/Newnes. ISBN 0750677562
In fact chapter 13 of my book is a Purchase Order generator.
I am attaching an unpublished chapter of the book that deals with generating in-house part numbers (and also how to use the sendkeys function in VBA)