Transferring Data from one sheet to another

[Fkerr]

Hi,

I am trying to set up a macro or something that will allow me to transfer
specific data from a master sheet. The master sheet is filled in with lots of
information and I want to pull just a few fields from that row. Is this
possible and can anyone help me try and figure this out?

 

[Pete_UK]

Well, you will have to give a lot more detail if you want some help on
this. What columns do you use in your master sheet? How many rows?
What fields do you want to copy into your summary sheet? What
condition(s) will determine the records to transfer? etc.

Pete

 

[Joel]

Sub CreateNewSht()

Set OldSht = ActiveSheet
Set NewSht = Sheets.Add(after:=Sheets(Sheets.Count))
With OldSht
NewSht.Range("A1").Value = OldSht.Cells(ActiveCell.Row, "H").Value
NewSht.Range("B1").Value = OldSht.Cells(ActiveCell.Row, "E").Value
NewSht.Range("C1").Value = OldSht.Cells(ActiveCell.Row, "L").Value
NewSht.Range("D1").Value = OldSht.Cells(ActiveCell.Row, "P").Value
End With
End Sub