Hi
I am trying to copy the data from two sheets in to one
Sheets("Details").Range("a2:m2").Select
Selection.Copy
Dim Row As Long
Dim ws1 As Worksheet
Set ws1 = Worksheets("list")
Row = ws.Cells.Find(What:="", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
this works well for a single sheet but don't know how to get the information from two sheets and add it to one sheet.
thanks
kevin
I am trying to copy the data from two sheets in to one
Sheets("Details").Range("a2:m2").Select
Selection.Copy
Dim Row As Long
Dim ws1 As Worksheet
Set ws1 = Worksheets("list")
Row = ws.Cells.Find(What:="", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
this works well for a single sheet but don't know how to get the information from two sheets and add it to one sheet.
thanks
kevin