london

I need a vba code to copy multiple columns from sheet1 and paste as list in sheet2 Here is current data format in sheet1 <tbody> H G H I J K L M 16 001/2018 002/2018 003/2018 17 8000 9000 9500 18 London NewYork Paris 19 GL acct Name Plan...

I am very rusty on VBA and need some help! I need to delete rows within a range (rows 6 to 85) if the value in Column A does not equal B2. I have pasted some example data below <colgroup><col><col><col><col></colgroup><tbody> A B C 1 Currency GBP 2 Employee Charlie 3 4...

I use the googlefinance function in google sheets to import financial data from into an excel sheet. Since last night london share tickers were returning #N/A. I've change my tickers from the form "ABC.L" where the L is for london to "LON:ABC" and all has come good. Hope that helps someone else!

Hello all, what a wonderful place this is...loads to learn here, just need a bit more time to browse the posts. In the mean time, I have a question to pose of my own, it has so far caused me to waste a huge amount of time, and effort...and I have got nowhere. I hope you may be able to help...

Hello All I have a spreadsheet containing name of suppliers (lawyers) and the full address of their law chambers. I am trying to extract only the name of the chambers from the full address. The name will then populate under "Name of Chamber" column. I am stumped as to how to go about doing...

Hello, I have a huge table of place names and corresponding data. I now have an update for this data (these have been entered underneath the table) and need to to copy them in for the individual place names. Therefore, for London for example, I would like to search the whole spreadsheet and...

Hi, I have a basic spreadsheet with 4 columns of data: Column A contains a date Column D contains a numeric value I want to run a macro/query that outputs the total numeric values for any given date. e.g. <colgroup><col><col span="2"><col></colgroup><tbody> Week Commencing Name...

I need to implement some functionality that will show a map of for example Europe and dependent on a list of cities and values for the cities, have a marker placed on the map where the city is and the marker, say a grey circle, be a size relative to all the other values in the list. For example...

Hi, I have a existing data file that contains address a whole address in one cell : Mr Smith 9 The Steet LONDON UK I need to now split each line into seprate cells: A1 - Mr Smith A2 - 9 The Street A3 - LONDON A4 - UK Any ideas ? Using Office 365 Excel 1708 Build 8431.2079 Thanks

Hi I'm a new member here, nice to meet all of you :) I am trying to create a VLookup function which will give an area by using a postcode (UK). I have followed directions on another website by searching 'determining a state from an area code' but I am getting a #VALUE ! error when using their...

Hello everyone. I am trying to do a SUMIF where the range consists of multiple columns and rows rather than just a single column. for example: <tbody> A B C D 1 Store 1 Store 2 Store 3 Store 4 2 London Chicago Paris 5 3 Paris NY Ottawa 18 4 Edinburgh Ottawa Paris 21 5 Edinburgh...

Apologies if this is simple and/or covered elsewhere, I'm not sure of what to search for to get what I'm after! Below is an example of my dummy file (apparently I can't add attachments) <tbody> Name Project Office Jim Alpha London Jim Alpha London Sandra Alpha London Jim Omega London...

On 22nd Nov 2014 we are hosting a SQL Saturday in London. It is being done under the umbrella of the PASS organisation, SQL Saturday is their free community events, but this is a very different SQL Saturday. We are aiming it Excel Pros who munge/crunch/manage data. There will be the usual nods...

Hi I would like to do a course in London with advanced Excel (ie VBA). I do not know much about the programming but am at that level. Please let me know your experiences