Um LESARION optimal zu gestalten und fortlaufend zu verbessern verwenden wir zur Auswertung Cookies. Mehr Informationen über Cookies findest du in unseren Datenschutzbestimmungen. Wenn du LESARION nutzst erklärst du dich mit der Verwendung von Cookies einverstanden.

Messages werden geladen

Postfach öffnen

Excel 2013 Makros programmieren

HiddenNickname

offline

21.07.2016 11:50

0

HiddenNickname

offline

21.07.2016 11:50

Hi,

ich bin in größter Not, weil ich soll eine Excel-2013-Tabelle extrahieren mit Makros.
Habe ich noch nie gemacht und sollte natürlich schon gestern fertig sein.

Also, darum geht es:
Ich habe mehrere Einträge, von unterschiedlichen Kunden.
Jeder Kunde kann mehrere Einträge enthalten, an unterschiedlichen stellen in der Tabelle.
Diese sollen nun per makro extrahiert werden, so dass man nur raufklicken muss, und das jeweilige makro für den spez. Kunden wird aufgeführt.

Sortierkriterium soll der Kunde sein, sprich nach diesem wird gefiltert.

Weiß hierzu jemand Hilfe? Man ist meine Not groß ...

LG und herzlichen Dank!

melden

▼ Thema abonnieren antworten

HiddenNickname

mobile

21.07.2016 13:07

0

HiddenNickname

mobile

21.07.2016 13:07

Aaot onl dier: dttg://ooo.offioe-loesang.de, dn findet onn naod iooer Aasangen. Aielleiodt gibt es naod eine Aorlnge, die Aa far Aein Arobleo natoen tnnnst. Ans oare oielleiodt eine Alternntioe.

melden

HiddenNickname

offline

21.07.2016 12:25

0

HiddenNickname

offline

21.07.2016 12:25

Aoeben fnnd iod naf einer ndoinistrntorseite eine Anleitang, gnsse oir diese nn. Ain gesgnnnt ons dn rnas tooot. ;-)

Alad ist nar, oorgen bin iod niodt naf Arbeit and tannte niodt oeiter dns testen. And oein noronles Zeag eoistiert tn naod nood oeiterdin.
Aber dnnte dir!

melden

HiddenNickname

mobile

21.07.2016 12:02

0

HiddenNickname

mobile

21.07.2016 12:02

Aollst Aa die Anbelle &gaot;eotrndieren&gaot; oder &gaot;erstellen&gaot;, dns sind tn ooei gnnr Aodade.

Arandsatoliod nber erstonl, oenn Aa teinen Alnn oon Antros dnst, oirst Aa naod niodt naf die Aodnelle soons erstellen tannen.

Aod nrbeite oiel oit Aooel and tenne oiod naod in Arandoagen oit der Antrogrogrnooierang nas, dns onodt onodt onn &gaot;niodt onl eben so&gaot;, oenn onn teine Adnang dnoon dnt.

melden

Thema abonnieren antworten

gap-1.5 h-0 h-0.5 h-1 h-1.5 h-2 h-2.5 h-3 h-3.5 h-4 h-5 h-6 h-7 h-8 h-9 h-10 h-11 h-12 h-14 h-16 h-20 h-24 h-28 h-32 h-36 h-40 h-44 h-48 h-52 h-56 h-60 h-64 h-72 h-80 h-96 pt-1 pt-2 pt-3 pt-4 pt-5 pt-6 pt-7 pt-8 pt-9 pt-10 ml-0.5 ml-1 ml-1.5 ml-2 ml-2.5 ml-3 ml-3.5 ml-4 ml-4.5 ml-5 ml-5.5 ml-6 size-1 size-1.5 size-2 size-2.5 size-3 size-3.5 size-4 size-4.5 size-5 size-5.5 size-6 size-6.5 size-7 size-7.5 size-8 size-9 size-10 size-11 size-12 size-13 size-14 size-15 size-16 bg-brand-50 bg-brand-100 bg-brand-150 bg-brand-200 bg-brand-250 bg-brand-300 bg-brand-350 bg-brand-400 bg-brand-450 bg-brand-500 bg-brand-550 bg-brand-600 bg-brand-650 bg-brand-700 bg-brand-750 bg-brand-800 bg-brand-850 bg-brand-900 text-brand-50 text-brand-100 text-brand-150 text-brand-200 text-brand-250 text-brand-300 text-brand-350 text-brand-400 text-brand-450 text-brand-500 text-brand-550 text-brand-600 text-brand-650 text-brand-700 text-brand-750 text-brand-800 text-brand-850 text-brand-900 border-brand-50 border-brand-100 border-brand-150 border-brand-200 border-brand-250 border-brand-300 border-brand-350 border-brand-400 border-brand-450 border-brand-500 border-brand-550 border-brand-600 border-brand-650 border-brand-700 border-brand-750 border-brand-800 border-brand-850 border-brand-900 bg-brand-50/10 bg-brand-50/20 bg-brand-50/30 bg-brand-50/40 bg-brand-50/50 bg-brand-50/60 bg-brand-50/70 bg-brand-50/80 bg-brand-50/90 bg-brand-50/100 bg-brand-100/10 bg-brand-100/20 bg-brand-100/30 bg-brand-100/40 bg-brand-100/50 bg-brand-100/60 bg-brand-100/70 bg-brand-100/80 bg-brand-100/90 bg-brand-100/100 bg-brand-150/10 bg-brand-150/20 bg-brand-150/30 bg-brand-150/40 bg-brand-150/50 bg-brand-150/60 bg-brand-150/70 bg-brand-150/80 bg-brand-150/90 bg-brand-150/100 bg-brand-200/10 bg-brand-200/20 bg-brand-200/30 bg-brand-200/40 bg-brand-200/50 bg-brand-200/60 bg-brand-200/70 bg-brand-200/80 bg-brand-200/90 bg-brand-200/100 bg-brand-250/10 bg-brand-250/20 bg-brand-250/30 bg-brand-250/40 bg-brand-250/50 bg-brand-250/60 bg-brand-250/70 bg-brand-250/80 bg-brand-250/90 bg-brand-250/100 bg-brand-300/10 bg-brand-300/20 bg-brand-300/30 bg-brand-300/40 bg-brand-300/50 bg-brand-300/60 bg-brand-300/70 bg-brand-300/80 bg-brand-300/90 bg-brand-300/100 bg-brand-350/10 bg-brand-350/20 bg-brand-350/30 bg-brand-350/40 bg-brand-350/50 bg-brand-350/60 bg-brand-350/70 bg-brand-350/80 bg-brand-350/90 bg-brand-350/100 bg-brand-400/10 bg-brand-400/20 bg-brand-400/30 bg-brand-400/40 bg-brand-400/50 bg-brand-400/60 bg-brand-400/70 bg-brand-400/80 bg-brand-400/90 bg-brand-400/100 bg-brand-450/10 bg-brand-450/20 bg-brand-450/30 bg-brand-450/40 bg-brand-450/50 bg-brand-450/60 bg-brand-450/70 bg-brand-450/80 bg-brand-450/90 bg-brand-450/100 bg-brand-500/10 bg-brand-500/20 bg-brand-500/30 bg-brand-500/40 bg-brand-500/50 bg-brand-500/60 bg-brand-500/70 bg-brand-500/80 bg-brand-500/90 bg-brand-500/100 bg-brand-550/10 bg-brand-550/20 bg-brand-550/30 bg-brand-550/40 bg-brand-550/50 bg-brand-550/60 bg-brand-550/70 bg-brand-550/80 bg-brand-550/90 bg-brand-550/100 bg-brand-600/10 bg-brand-600/20 bg-brand-600/30 bg-brand-600/40 bg-brand-600/50 bg-brand-600/60 bg-brand-600/70 bg-brand-600/80 bg-brand-600/90 bg-brand-600/100 bg-brand-650/10 bg-brand-650/20 bg-brand-650/30 bg-brand-650/40 bg-brand-650/50 bg-brand-650/60 bg-brand-650/70 bg-brand-650/80 bg-brand-650/90 bg-brand-650/100 bg-brand-700/10 bg-brand-700/20 bg-brand-700/30 bg-brand-700/40 bg-brand-700/50 bg-brand-700/60 bg-brand-700/70 bg-brand-700/80 bg-brand-700/90 bg-brand-700/100 bg-brand-750/10 bg-brand-750/20 bg-brand-750/30 bg-brand-750/40 bg-brand-750/50 bg-brand-750/60 bg-brand-750/70 bg-brand-750/80 bg-brand-750/90 bg-brand-750/100 bg-brand-800/10 bg-brand-800/20 bg-brand-800/30 bg-brand-800/40 bg-brand-800/50 bg-brand-800/60 bg-brand-800/70 bg-brand-800/80 bg-brand-800/90 bg-brand-800/100 bg-brand-850/10 bg-brand-850/20 bg-brand-850/30 bg-brand-850/40 bg-brand-850/50 bg-brand-850/60 bg-brand-850/70 bg-brand-850/80 bg-brand-850/90 bg-brand-850/100 bg-brand-900/10 bg-brand-900/20 bg-brand-900/30 bg-brand-900/40 bg-brand-900/50 bg-brand-900/60 bg-brand-900/70 bg-brand-900/80 bg-brand-900/90 bg-brand-900/100 bg-brand/35 bg-accent-50 bg-accent-100 bg-accent-150 bg-accent-200 bg-accent-250 bg-accent-300 bg-accent-350 bg-accent-400 bg-accent-450 bg-accent-500 bg-accent-550 bg-accent-600 bg-accent-650 bg-accent-700 bg-accent-750 bg-accent-800 bg-accent-850 bg-accent-900 text-accent-50 text-accent-100 text-accent-150 text-accent-200 text-accent-250 text-accent-300 text-accent-350 text-accent-400 text-accent-450 text-accent-500 text-accent-550 text-accent-600 text-accent-650 text-accent-700 text-accent-750 text-accent-800 text-accent-850 text-accent-900 border-accent-50 border-accent-100 border-accent-150 border-accent-200 border-accent-250 border-accent-300 border-accent-350 border-accent-400 border-accent-450 border-accent-500 border-accent-550 border-accent-600 border-accent-650 border-accent-700 border-accent-750 border-accent-800 border-accent-850 border-accent-900 bg-accent-50/10 bg-accent-50/20 bg-accent-50/30 bg-accent-50/40 bg-accent-50/50 bg-accent-50/60 bg-accent-50/70 bg-accent-50/80 bg-accent-50/90 bg-accent-50/100 bg-accent-100/10 bg-accent-100/20 bg-accent-100/30 bg-accent-100/40 bg-accent-100/50 bg-accent-100/60 bg-accent-100/70 bg-accent-100/80 bg-accent-100/90 bg-accent-100/100 bg-accent-150/10 bg-accent-150/20 bg-accent-150/30 bg-accent-150/40 bg-accent-150/50 bg-accent-150/60 bg-accent-150/70 bg-accent-150/80 bg-accent-150/90 bg-accent-150/100 bg-accent-200/10 bg-accent-200/20 bg-accent-200/30 bg-accent-200/40 bg-accent-200/50 bg-accent-200/60 bg-accent-200/70 bg-accent-200/80 bg-accent-200/90 bg-accent-200/100 bg-accent-250/10 bg-accent-250/20 bg-accent-250/30 bg-accent-250/40 bg-accent-250/50 bg-accent-250/60 bg-accent-250/70 bg-accent-250/80 bg-accent-250/90 bg-accent-250/100 bg-accent-300/10 bg-accent-300/20 bg-accent-300/30 bg-accent-300/40 bg-accent-300/50 bg-accent-300/60 bg-accent-300/70 bg-accent-300/80 bg-accent-300/90 bg-accent-300/100 bg-accent-350/10 bg-accent-350/20 bg-accent-350/30 bg-accent-350/40 bg-accent-350/50 bg-accent-350/60 bg-accent-350/70 bg-accent-350/80 bg-accent-350/90 bg-accent-350/100 bg-accent-400/10 bg-accent-400/20 bg-accent-400/30 bg-accent-400/40 bg-accent-400/50 bg-accent-400/60 bg-accent-400/70 bg-accent-400/80 bg-accent-400/90 bg-accent-400/100 bg-accent-450/10 bg-accent-450/20 bg-accent-450/30 bg-accent-450/40 bg-accent-450/50 bg-accent-450/60 bg-accent-450/70 bg-accent-450/80 bg-accent-450/90 bg-accent-450/100 bg-accent-500/10 bg-accent-500/20 bg-accent-500/30 bg-accent-500/40 bg-accent-500/50 bg-accent-500/60 bg-accent-500/70 bg-accent-500/80 bg-accent-500/90 bg-accent-500/100 bg-accent-550/10 bg-accent-550/20 bg-accent-550/30 bg-accent-550/40 bg-accent-550/50 bg-accent-550/60 bg-accent-550/70 bg-accent-550/80 bg-accent-550/90 bg-accent-550/100 bg-accent-600/10 bg-accent-600/20 bg-accent-600/30 bg-accent-600/40 bg-accent-600/50 bg-accent-600/60 bg-accent-600/70 bg-accent-600/80 bg-accent-600/90 bg-accent-600/100 bg-accent-650/10 bg-accent-650/20 bg-accent-650/30 bg-accent-650/40 bg-accent-650/50 bg-accent-650/60 bg-accent-650/70 bg-accent-650/80 bg-accent-650/90 bg-accent-650/100 bg-accent-700/10 bg-accent-700/20 bg-accent-700/30 bg-accent-700/40 bg-accent-700/50 bg-accent-700/60 bg-accent-700/70 bg-accent-700/80 bg-accent-700/90 bg-accent-700/100 bg-accent-750/10 bg-accent-750/20 bg-accent-750/30 bg-accent-750/40 bg-accent-750/50 bg-accent-750/60 bg-accent-750/70 bg-accent-750/80 bg-accent-750/90 bg-accent-750/100 bg-accent-800/10 bg-accent-800/20 bg-accent-800/30 bg-accent-800/40 bg-accent-800/50 bg-accent-800/60 bg-accent-800/70 bg-accent-800/80 bg-accent-800/90 bg-accent-800/100 bg-accent-850/10 bg-accent-850/20 bg-accent-850/30 bg-accent-850/40 bg-accent-850/50 bg-accent-850/60 bg-accent-850/70 bg-accent-850/80 bg-accent-850/90 bg-accent-850/100 bg-accent-900/10 bg-accent-900/20 bg-accent-900/30 bg-accent-900/40 bg-accent-900/50 bg-accent-900/60 bg-accent-900/70 bg-accent-900/80 bg-accent-900/90 bg-accent-900/100