manchester

Hi I a trying to create a macro that will merge a number of cells in a column based on a value in another cell the spreadsheet is laid out Column A Column B Column C Column D Column E City ProductID Cost Total Amount Count London 001...

hi folks, I am trying to solve trailer load allocation planning.This would have been easier if i had w*h*d in my data set, but i have a combination of products for a particular trailer type.And i have multiple dealers/destination spreaded across the region. Have attached below a scenario which...

Hi In column "L" I have a list of cities/countries: Toronto, Ont., Canada Montreal, Que., Canada Toronto, Ont., Canada Manchester, England, United Kingdom New York City, New York, United States Frankfurt, Germany Abuja, Nigeria Frankfurt, Germany Manchester, England, United Kingdom Doha, Qatar...

Hi I've found the workaround for this issue, but don't understand why it was an issue: I did all the hard work of writing the queries in Access and some of the queries involve sub-queries e.g. Pretend I wanted queries that prepared data on Goals, Assists, Wages, Corners So inside Access, the...

I am looking for a formula to solve the following problem. Say I have a data range of A2:A6 <tbody> Cell (A1) Name A2 Manchester, UK | Chester, UK A3 Chester A4 Manchester, UK A5 Chesterfield, UK A6 Chester, UK </tbody> I would like for the result to be '3' as Chester is in A2, A3...

Hi, I wonder if someone can help me please. I have a spreadsheet that has a validation list in column A and then other date in columns B to I. I would like to change the colour of a row (all the data in that row) when certain 'Locations' are selected from the validation drop down list. E.G. If...

Hi, First of all thanks in advanced for your help. I'm fairly new to coding VBA in Excel. so I have managed to create the following code (which works as intended) and I am curious to know if there is anyway to simplify it as I need to add more lines to it. The intended result is that when a...