Track Purchase Orders for multiple locations

[chinitapr]

Hello. My company has 22 stores, I place the orders as they come in from stores. I want to create a workbook to track what each of the 22 stores is ordering (when and how much) Any ideas???

[newdoverman]

I'm surprised that a company with 22 stores doesn't have software already in place to take care of this.

You could have a simple listing by date, store ID, description of item ordered, and other details each in their own column. Create this in a table or range with filters so there isn't any need to have a worksheet for each store. All can be on one worksheet. It doesn't have to be complicated.

This is very simple but maybe it will give you some ideas.

[chinitapr]

Thanks newdoverman. Its a good start.

[newdoverman]

Thank you for the feedback.

[chinitapr]

Hi again, the first idea is working. I made a worksheet called Item Description with the Item name and Description in the Adjacent column. On the Purchase Orders worksheet, I made a drop down list to pull the Item from the other worksheet. I want for the adjacent cell to auto fill on this worksheet once a selection has been made from drop down list. Any ideas?

[newdoverman]

Pictures are fine but they cannot be worked with.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[chinitapr]

I tried to upload initially and I kept getting a broken message. That's why I sent the pictures. Hoping it works this time. WSI Purchase Order Copy - Copy.xlsx

[newdoverman]

This should help you out. I only copied the formulae down to row 20 so if you want more just copy as far as you need.

[chinitapr]

Oh my!!! newdoverman, You are awesome! That is exactly what I needed! Thank you soooooo much

[newdoverman]

Thank you for the compliment.

That is just a start. You can do the same thing for the store names and IDs. If you add a date column that will allow you to track items or purchases over a period of time. If you add the date, make sure that it is in Excel acceptable date format. Then, you can add from the Data tab, Filters so that you can pull the records from any of the columns.