Automate task in vba

[plutonik33]

Hi,

I don't have vba experience, but I really need to solve the following tasks:

First table has to be filtered by unique users.
Filtered table then needs to be stored in a new document and named after the name of the user.

Plus it would be amazing if I can then send the generated documents attached as an email with subject text and additional information like "Dear User, ...." (Using Outlook).

Appreciate any help!

Here is my Mini-sheet:

Filter by column 'User'.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Reihenfolge	EndSZ	SM-Auftrags-nummer	Position für Google Maps	Straße	PLZ	Ort	Prio	Tausch gegen	ON	ONKZ	AsB	Region_PTI	Material-nummer	Jahr	Kalender-woche	Wartungs-fenster	User	Wartungs-fenster Datum	Beginn Wartungs-fenster	Ende Wartungs-fenster	IP
2	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S1	xx	xx	xx	xx
3	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S1	xx	xx	xx	xx
4	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S2	xx	xx	xx	xx
5	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S2	xx	xx	xx	xx
6	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S3	xx	xx	xx	xx
7	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S3	xx	xx	xx	xx
8	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S4	xx	xx	xx	xx
9	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	xx	S4	xx	xx	xx	xx
Tabelle2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A9	Expression	=#BEZUG!="nein"	text	NO
H2:H9	Cell Value	="entfällt"	text	NO
H2:H9	Cell Value	="entfällt"	text	NO
B2:V9	Expression	=#BEZUG!="nein"	text	NO
B1	Cell Value	duplicates	text	NO

 

[mumps]

Since this is a new requirement, you should start a new thread.

 

[plutonik33]

Since this is a new requirement, you should start a new thread.

Alright^^