Citat:
srdrazic: Postoji li mogućnost da se automatski nastavi niz slogova pritiskom na enter ili neko dugme u sheet2.
Na netu ima dosta VBA kodova za kopiranje na drugi Sheet,
Evo jedan ne baš elegantan , možda netko nabaci nešto jednostavnije.
Code:
Sub CopyWithNonBlanksRow()
Dim NR As Long
Dim InS As Worksheet
Dim OuS As Worksheet
Dim newRow As Integer
Dim colIndex As Integer
Dim rowIndex As Integer
Dim dataRange As Range
Set InS = Sheets("Sheet1")
Set OuS = Sheets("Sheet2")
Set dataRange = InS.Range("M12:N22")
NR = OuS.Range("A" & Rows.Count).End(xlUp).Row + 1
For rowIndex = 1 To dataRange.Rows.Count
If Application.CountIf(dataRange.Rows(rowIndex), "") < dataRange.Columns.Count Then
dataRange.Rows(rowIndex).Copy
OuS.Range("A" & NR).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=False
NR = NR + 1
End If
Next rowIndex
'Range("Emp,Manual,Role,OHrs,SHrs,Casual,CRate,AddType,AddHrs,FDate,TDate").Value = ""
Sheets("Sheet1").Select
Application.CutCopyMode = False
Range("E3").Select
End Sub