Kindly Help Me Excel Data Search

**tariqjahangir** · 06-21-2015, 03:28 PM

Dear Excel Forum Members 1) i have diffrent difftent supplier P.O with each folder difftent item so is it possible to search what item we want .some time my boss will ask me last time we have purchased that item what is the price of that? that time very dificult for me to find perticular item so kindly give me your reply and suggest me how to make that type of data quickly search the item from the po file. 2) some time we are facing problem for price difrences from the supplier (what i mean to say when i making the new po same item last time how much we purchase that price will need to display on po then i understand last time we purchase 335.00 riyals but now i received invoice from the supplier 350.00 Riyals...same item with price difrent i will inform the supplier or my boss so kindly suggest me reply me......Thanks my english is poor sorry ........

**ufopilot** · 06-22-2015, 12:51 AM

You would really need to start out with a database, where you have all information.
In the header sections you would have the Date, customer name, address, po #, Item #, Item description...etc
Then for each item you would start a new row.
Now you can easily use filters in the header section to find any criteria you need to look up. You can also use formulas, and/or macros to fill out purchase orders, invoices, reports, quotes etc.

I have attached a simple workbook that may get you started

**tariqjahangir** · 06-27-2015, 03:26 PM

Originally Posted by ufopilot

You would really need to start out with a database, where you have all information.
In the header sections you would have the Date, customer name, address, po #, Item #, Item description...etc
Then for each item you would start a new row.
Now you can easily use filters in the header section to find any criteria you need to look up. You can also use formulas, and/or macros to fill out purchase orders, invoices, reports, quotes etc.

I have attached a simple workbook that may get you started

Dear sir,

Thanks for your responce but still i no undestand i uploaded one more p.o could you please explain me with two p.o then i eassely undestand.iam waithing for your quick responce