Need help revamping Inventory & Sales spreadsheet

**lorne17** · 06-24-2013, 12:04 AM

Hey all,

I need some help getting some formulas working to call in items that match specific criteria in 2 or more columns on another tab.

It's kind of hard to explain here, but I put in comments in my spreadsheet on the tab "Store Inventory". This page I want to look through all 12 months (which I have listed in a table on the last tab) and pull the products that fall under the "Sales Type" (Column L in all months) when the Sales Type matches the title (cell 'Store Inventory'!B1). That's a quick summary, but my comments go further in depth.

Can anyone help me? I posted the document for you to see. I'm open to any further changes/alterations throughout the document. I found this online, and trying to get it to work well for consignment sales/purchases.

Thanks so much!

Lorne

PS-Random question, I was saving this as a .xlsx file and then when I added in this new tab and the comments, I couldn't save as a .xlsx so I saved back to .xls. Hopefully the older version didn't mess anything up.

**FDibbins** · 06-24-2013, 12:33 AM

I will take a look at your file, but just a quick suggestion...1 reason the forum asks for what version of excel you are using, is so that members can tailor suggestions based on the version you are using. Not all functions are available in earlier versions, so it will waste every-ones time if, for instance, we give a formula that included iferror(), and the OP is using 2003

**FDibbins** · 06-24-2013, 12:49 AM

Why do you have each month on its own sheet? It will make things much simpler of all data is on the same sheet?

**lorne17** · 06-24-2013, 01:37 AM

Thanks for the replies FDibbins.

I am using Excel Mac 2011.

They are on separate sheets because that's the template I downloaded from the internet. Again, I'm open to changing it up so if you know of a better option feel free to switch stuff around or make suggestions.

Thanks for the help!
Lorne

**lorne17** · 06-24-2013, 11:38 PM

Any update on this? It would be VERY much appreciated!

Thanks,
Lorne

**FDibbins** · 06-24-2013, 11:47 PM

Sorry, lost track of this thread, I will take a look again

**lorne17** · 06-26-2013, 09:13 PM

Thanks FDibbins. Any progress?

**FDibbins** · 06-27-2013, 05:53 PM

Again, sorry for the delay

Lets see if this is heading in the right direction for you?

I took the data for June, and put it a new sheet (Data), then copied June data again and changed it to July.

Store Inventory now references Data.