PDA

Vollständige Version anzeigen : Wie Zeilen Inhalte in Spalten neuer Tab?


gerstmichel
10.11.2005, 16:19
Hallo,

ich habe folgendes Problem:

Ich möchte jeweils die erste Zeile und die neueste Zeile n mit Ihren Inhalten in eine neue Tabelle (neues Blatt) in Spalte A (erste Zeile) und in Spalte B (Zeile n) kopieren

(Tabelle 1 Zeile 1 A-Z in Tabelle 2 Spalte A 1-27; Tabelle 1 Zeile n A-Z in Tabelle 2 Spalte B 1-27)

Wie kann ich da am einfachsten vorgehen? Gibt es da fertige Makros?

Danke und Gruß,
Michael

Woody
10.11.2005, 18:56
Hallo gerstmichel,

kopiere die Daten und wähle über rechte Maus, Inhalte einfügen, -->Transponieren.

Hajo_Zi
10.11.2005, 19:11
Hallo Michael,

ich gehe mal davon aus das Spalte A zuerst ausgefüllt wird.

<table><tr style="vertical-align:top; text-align:center; "><tr><td>Tabelle2</td></tr><tr><td><table border=1 cellspacing=0 cellpadding=0 style="font-family:Arial,Arial; font-size:10pt; padding-left:2pt; padding-right:2pt; "> <style type = "text/css"> th {font-weight:normal} </style> <colgroup><col width=30 style="font-weight:bold; "><col width=79.999998 ><col width=79.999998 ></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>&nbsp;</td><td>A</td><td>B</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="">Typ</td><td style="">Wert3</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="">Name1</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="">Name2</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="">Name3</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="">Name4</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="">Name5</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="">Name6</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="">Name7</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="">Name8</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="">Name9</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="">Name10</td><td style="">&nbsp;</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="">Name11</td><td style="">&nbsp;</td></tr></table><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#FFFCF9; "><tr><td><b>Formeln der Tabelle</b></td></tr><tr><td><table style="font-family:Arial; font-size:10pt;">B1 : =INDIREKT("Tabelle1!"&ADRESSE<span style=' color:008000; '>(ANZAHL2<span style=' color:#0000ff; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#0000ff; '>()</span>)</span>)<br>B2 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B3 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B4 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B5 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B6 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B7 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B8 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B9 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B10 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B11 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br>B12 : =WENN(INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>=0;"";INDIREKT<span style=' color:008000; '>("Tabelle1!"&ADRESSE<span style=' color:#0000ff; '>(ANZAHL2<span style=' color:#ff0000; '>(Tabelle1!$A:$A)</span>;ZEILE<span style=' color:#ff0000; '>()</span>)</span>)</span>)<br></table></td></tr></table></td></tr><tr><td>&nbsp;</td></tr></tr></table> <span style="font-family:'Arial'; font-size:9pt;font-weight:bold; ">Diagramm - Grafik - Excel Tabellen einfach im Web darstellen&nbsp;&nbsp;<a style ="font-family:'Arial'; font-size:9pt; color:#FCF507; background-color:#1506F7; font-weight:bold;" href='http://www.haserodt.de/ejh_do/ex_jean_info.htm' target='blank'>&nbsp;&nbsp;Excel Jeanie HTML&nbsp;&nbsp;3.0&nbsp;&nbsp;&nbsp;&nbsp;Download&nbsp;&nbsp;</a></span><br>

<img src="http://home.media-n.de/ziplies/images/grusz.gif" align="middle" height="40" alt="Grußformel">
<a href="http://home.media-n.de/ziplies/" target="_blank">
<img border="0" src="http://home.media-n.de/ziplies/images/logo_hajo.gif" align="middle" height="40" alt="Homepage"></a>