Hi all,
New to Mr Excel and hoping you can help with the below, i have recorded a macro to copy values from from one tab and paste them into a row "A" on the next tab and i found a string which is supposed to paste all the data to the next available row when the macro runs but it is pasting to the first row each time,
can some one help,
Sheets("Matrix").Select
ActiveSheet.Unprotect
Sheets("Raise a CI").Select
Range("B6").Select
Selection.Copy
Sheets("Matrix").Range("A" & Rows.Count).End(xlUp).Offset(1).
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Raise a CI").Select
Range("B3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Matrix").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
New to Mr Excel and hoping you can help with the below, i have recorded a macro to copy values from from one tab and paste them into a row "A" on the next tab and i found a string which is supposed to paste all the data to the next available row when the macro runs but it is pasting to the first row each time,
can some one help,
Sheets("Matrix").Select
ActiveSheet.Unprotect
Sheets("Raise a CI").Select
Range("B6").Select
Selection.Copy
Sheets("Matrix").Range("A" & Rows.Count).End(xlUp).Offset(1).
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Raise a CI").Select
Range("B3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Matrix").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False