Help with creating a script with VBA

lenziwag93 · #2 04-20-2022, 12:57 AM

Thats what i got for bullet point 1:

Code:

Sub CopyRowE() Dim LastRowE As Long Dim LastRowH As Long Dim LastDataRow As Long Dim CopyData As Long  With Tabelle1  LastRowE = .Range("E9999").End(xlUp).Row LastRowH = .Range("H9999").End(xlUp).Row  .Range("E2:E" & LastRowE).Copy .Range("CA1").PasteSpecial .Range("H2:H" & LastRowH).Copy .Range("CB1").PasteSpecial  LastDataRow = .Range("CB999999").End(xlUp).Row .Range("CA1:CB" & LastDataRow).Copy  Sheets.Add  ActiveSheet.Range("A1").PasteSpecial  .Range("CA1:CB" & LastDataRow).ClearContents  Tabelle1.Select .Range("A1").Select  End With End Sub

Any idea for the other bullet points? How can i do the same for a different file?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Script Directory	charlesdh	Excel Programming	3	06-12-2018 01:36 PM
Run a script disappeared, now what?	ProgramSam	Outlook	2	02-19-2018 05:00 AM
Outlook VBA Script	kcm5153	Outlook	1	04-07-2015 11:41 PM
Bolding in script	ksigcajun	Word VBA	10	02-23-2015 08:29 AM
Help with VBA script	nsyrax	Word VBA	1	01-18-2014 03:38 AM