glass

Hello all I have in 2 columns a couple of strings in a cell Is it possible to index a master table and count how many times do they match? ex. Master table <colgroup><col><col><col><col><col></colgroup><tbody> 43706 T_C6000 Cabin Door - Glass - Deeper Door SMC00377 215404 43915 T_C6001 Cabin...

Hi all, hope you can help please!! I have a s/sheet with many columns of categories (types of items sold) that have our stores (listed as store numbers) listed from high to low in each column. I want to create a summary tab for each store, listing their rank in each category. Top is what I...

Hi, I am trying to send multiple attachments on an email. I am using the following code to send a single attachment however I would like to send all the attachments located in Column C on a sheet named "ITEM INQUIRY LIST" With OutMail .To = Range("P8").Value .CC =...

Hi all, I work at a glazier and I am trying to create a grid for the office girls to work from to be able to quote people over the phone easily. We cut glass from standard sheet sizes that we stock so there is a size range to work from and here is an example: <colgroup><col width="206"><col...

I want to make a price list for all the glass we supply. In column A I would list all our products. As we sell glass on a square metre rate is there a way I can select a product from say A5 and the input the height of the glass in b5 and the width in d5 and in that row set a sq metre rate and...

Here is my data : A1= Sequential number B1 = Part ID C1 =Area D1= Target So that : A2 = 500 B2 = 500-G C2= Production office D2 = Office Door E2 = Glass I want to generate B2 by having an if formula that if E2 =glass than add the suffix "-G" ro A2 so that it becomes 500-G,otherwise add...

Hi I'm trying to put together a price list to help make life easier for myself and I'm finding out little by little how powerful excel can be. However, I've hit a stumbling block. I have a list where I can select appropriate options and accessories for windows (the one's you look out of not...

I am currently working on a big project, and need to fill in the pricing schedule. In table 1, I would like an easy way to fill in the question marks. I have over 150 "cars" to fill in, so I am looking for the best solution to get this automated. I am used to work with Vlookup, but I have over...