Generate a Vendor List?

[trav12d]

Hi, I have a restaurant concept in Los Angeles. I have created some liquor cost spreadsheets comparing our depleted inventory with sales. I also have a column of PAR amounts for the bottles for the minimum we should always have on hand. I am trying to create a formula so that if a certain bottle is low in stock, it will list it on another worksheet under the corresponding vendor. That way when I am done with inventory, I have a sheet of all products needed to order grouped by vendor. The initial worksheet is grouped by vodkas, gins, etc so the vendors are random. I am not sure what term to use to search any tutorial lists for this feature. Any help....??

 

[Aladin Akyurek]

Would you post a tiny sample of inventory and re-order levels?

 

[trav12d]

How do I post a sample?

 

[trav12d]

.

 

[Aladin Akyurek]

.

Try one of these MrExcel HTML Maker, Excel jeanie or Borders-Copy-Paste

 

[trav12d]

That file maker is beyond my skill set. When I opened the application it asked me about macros...

I REALLY appreciate your help and interest in my dilemma.. can I email the file to you?

My restaurant is called CONGREGATION Ale House in Long BEach, CA. My email is info@congregationalehouse.com.

And my name is Travis, thank you again for your help!!

 

[Aladin Akyurek]

That file maker is beyond my skill set. When I opened the application it asked me about macros...

I REALLY appreciate your help and interest in my dilemma.. can I email the file to you?

My restaurant is called CONGREGATION Ale House in Long BEach, CA. My email is info@congregationalehouse.com.

And my name is Travis, thank you again for your help!!

Borders-copy-paste should not be difficult to use. Would you try that method?

 

[trav12d]

I have a mac, it is not working...

 

[trav12d]

I posted it on my 'cloud', but it is asking me for an email to share it with you. This is the only place I know how to post it...