audi

Guys, Please can someone have a look at the below code. It essentially looks at 12 different tables and removes anything that is not "1st Attempt Made" in column D. Its doesn't seem to work all the time and sometimes leaves 'New Calls', '2nd attempt made; etc in some of the tables. Sorry if...

Hi Guys, Could someone help me with the below. I have recorded this Macro but i need to adapt it so it filters and deletes all rather than look at specific rows. I essentially want to select 6 worksheets in total, filter by column D and delete anything that does not show 'New Calls' Thanks...

Hi, I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers. Fo example: Sheet A (2015) AUDI BMW Toyota Ford Volvo Volvo Sheet B (2016) BMW Citroen BMW BMW AUDI In each sheet, a manufacturer can be stated several times. I need...

Guys, there are 2 tables below. The data table and a lookup table. Is this possible? I have a list of cars and i want to pull back the brand name. At the moment i am simply adding all the vehicles from the data table into a lookup table and pulling back the brand name from that. However...

I’m finding this very hard to get working the way I’d like to, I’ve been trying to use a combination of ADDRESS, SUBSTITUTE, MATCH and it’s all getting a bit unwieldy. I have two data sources that I want to compare to make sure the values are the same. One has all numerical values in a single...

Hello and thank to anyone that could help with this one. What I would like to do is to make macro that will copy entire rows based on criteria from 3 different sheets into 1. At first I would like to copy First row from sheet Audi Q7 with header and then if in any of the last 4 columns (sheet...

Guys, How do i change the below to paste as value to the last row of the Sheets("BA Audi SMOT NC Values") Sheets("BA Polk Audi Serv & MOT N Calls").Select Cells.Select Selection.Copy Sheets("BA Audi SMOT NC Values").Select Selection.PasteSpecial Paste:=xlPasteValues...

If I want to have the same color following a for example a "brand" in a graph. Excel automatic set colours depending on the value, but if I for ex in my graphs always want that AUDI to displayed in RED and BMW displayed as BLUE. What function must I use ?

Hello I have the table below <tbody> A B 1 Audi 2 0 Audi 3 Skoda Ford 4 Nissan 5 Ford Skoda 6 VW 0 7 Nissan 0 </tbody> In cell B2 I placed the formula...

I have The following in a table in Cell A1:B6 I have the Car (Audi BMW) listed in cell C1 and D1. And need to obtain all the names under each car. eg tom and tim would be under BMW. Need this in a VBA code please <tbody> NAme Car phil Audi andy Audi jack Audi tom BMW tim BMW </tbody>

How do I set a countif but dont want to count duplicate names? Example a sales team of 5 sold x number of iteams but then Adams name may come up several times due to mutiple things sold. I just want the countif to count name once? example below Sorry having some issues in upload I'll give you...