shirt

I need an excel spreadsheet that shows all the available combinations for a wardrobe. I think I have the logic right, but need a confirmation if this is right. List of wardrobe items: Logic for formula. Not sure the is correctx = 7 topsy = 6 Bottomsz = 5 Jacketsw = 4 Shoesv = 2 T-Shirtsn = #...

I have a table of items that are assigned a fixed cost. Example: Item) Name) Price 1) Red Ruby Shirt) $35.22 2) Blue Tuxedo) $47.90 On a separate sheet I have a UserForm with a list box that grabs the table from the other sheet. I would like...

Hi Guys, I am having an issue which a spreadsheet where I have a list of stock <tbody> item SKU TYPE SIZE Starting QTY Running Qty Shirt SS-5XS SS 5XS 8 Shirt SS-3XS SS 3XS 23 Shirt LS-3XS LS 3XS 2 Shirt LS-2XS LS 2XS 25 </tbody> I then have a table which lists all items the...

Hello, I am going to be importing a CSV file into a sheet weekly and need the column to line up properly. The Comma Seperated list I am importing does not account for spaces I need for the excel sheet. I made a dummy table below. Every person is ordering a shirt, a hat, shoes, or any...

I've got a BOM in the following format: <tbody> Item Description 1 Pants 1.1 Right Pants Pocket 1.1.1 Keys 1.1.2 Change 1.1.3 Phone 1.2 Left Pants Pocket 1.3 Back Pants Pocket 1.3.1 Wallet 1.3.2 Comb 2 Hat 3 Shirt 3.1 Right Shirt Pocket 3.2...

I am subtotaling orders for total pieces and weight. Example: ITEM.....PCS......WT............IN STOCK Shirt......5...........7.................96 Shirt......12.........16...............96 Shirt......3...........5..................96 ------------------------...

Hi, I am struggling with VBA syntax to implement a Max If over multiple conditions on dynamic ranges. I have a list of products and I want to find the most expensive according to 2 or more criterias. On top of it the list of products is dynamic. What would the correct syntax be for having a...

Tried posting this earlier but I can't find it so I will try again. I need to find the result from a VLOOKUP table(s) but which table to use will be dependent upon a series of conditions (over 200 different possible results of the input conditions). I was thinking that I could possibly store...