Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring Data from one sheet to another
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring Data from one sheet to another
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 On Aug 18, 11:14*am, Fkerr wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring Data from one sheet to another
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 "Fkerr" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring function results to another sheet | Excel Worksheet Functions | |||
Transferring a cell value to another sheet | Setting up and Configuration of Excel | |||
Transferring data from one sheet to another if criteria are met. | Excel Worksheet Functions | |||
transferring total sheet from one workbook to another | Excel Worksheet Functions | |||
vlookup...transferring info from 1 sheet to another.... | Excel Worksheet Functions |