Get the data part of a stuctured column in VBA

Hi,

May I just ask you where did you get the data set from? I download mine from Wikipedia and despite the formatting it still doesn't chart properly...

I would really appreciate the reply!

Thanks in advance!

M.

I would like to represent the districts / regions of Bavaria by means of an Excel 2019 map.
In part, this has worked well. Unfortunately, there are a few orange boxes where Excel can not find any data, even though they are in my spreadsheet.
Take the example of the district of Passau (on the far left of the map.) Excel recognizes the city / district of Hof, but unfortunately not completely.

Can someone help me here please?

Many thanks

LG

P.

Liebe Lisa
<br />Weil ich möchte, dass der Vorspann und Nachspann (Introduction, Mapping the Terrain und Conclusion) auf der gleichen Ebene stehen. Alles es ist wie alles die erste Ebene.
<br />Damit die Querverweise stimmen, muss ich machen, dass Part 1 etc. auch als Aufzählungszeichen vorkommt. Weil momentan ist es so, dass wenn ich bspw. auf Part 1 1. einen Querverweis machen will, dann kommt das als II 1. - was ich aber möchte ist Part 1 1.
<br />Das ist ein Ausschnitt aus dem Inhaltsverz.:
<br />I. Introduction
<br />II. Mapping the Terrain
<br />1. Starting Point: Definition of Key Terms
<br />a) Disclaimer
<br />b) Transnational Corporation (TNC)
<br />c) Regulation
<br />d) (Public/Private) International Law
<br />e) Home State
<br />2. Contextualising the Present Analysis
<br />a) The Wider Picture: Globalisation as a Starting Point
<br />b) The Need of Regulating
<br />c) TNCs – Regulatory Nuts to Crack
<br />i Preliminary Remarks
<br />ii State-based World Order and Flexibility of TNCs
<br />iii The Problem of (Inter)national Legal Personality (Subjectivity)
<br />iv The Problem of Legal «Nationality» of TNCs and the Problem of Jurisdiction
<br />3. Setting the Stage: Laying Out the Key Issues of this Analysis
<br />Part 1: Conceptual-Theoretical Part: The Concept of Transnational Law and Transnational Regulatory Corporate Governance
<br />1. Introduction to Part 1
<br />Vielen Dank!
<br />

Hi Fatima

Greetings! I am Vijay, an Independent Advisor. You can use VLOOKUP very easily.

Let's say that your second list has list of items in column E (please change E appropriately). Data starts in row 2.

And first list in column A and B of same sheet. Use following formula and drag down

=VLOOKUP(E2,A:B,2,0)

More robustly

=IFERROR(VLOOKUP(E2,A:B,2,0),"")

Now there may be a scenario that first list is in Sheet1 and second list is in another sheet starting in column A.

The use following formulas

=VLOOKUP(A2,'Sheet1'!A:B,2,0)

=IFERROR(VLOOKUP(A2,'Sheet1'!A:B,2,0),"")

Solved, hopefully - Some parts of the text were 'formatted' to English (US), so when I sliced it into pieces it jumped back to that language. Since this isn't a visible formatting, it can be treacherous since it's not obvious which parts of the text are
set to which language.

You are right about numbers not needing quotations marks.

In this case the marks are not delimting numbers, but parts of the sql-string:

- "INSERT INTO tblDetail ([Pid], [Bid]) VALUES ("

- ", "

- ")"

The string is build in this way because it consists of fixed parts (see above) and variable parts (the
values of lngProductID and lngBID).