Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before. Please
pardon my ignorance.

Thanks for your help

Hi Yossy

Start here
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Yossy" wrote in message ...
Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before. Please
pardon my ignorance.

Thanks for your help

Sorry Ron. I found a useful explanation in your link. Thanks a big bunch
"Ron de Bruin" wrote:

Hi Yossy

Start here
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Yossy" wrote in message ...
Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before. Please
pardon my ignorance.

Thanks for your help

please where do I copy the code in. i opened the vb and to be honest I have
no clue what to do. Please help and also after copying the code in what do i
do next. am sorry for silly question but please help me.

Thanks

"Yossy" wrote:

Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before. Please
pardon my ignorance.

Thanks for your help

Yossy,

A good place to start would be he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Yossy" wrote in message
...
please where do I copy the code in. i opened the vb and to be honest I
have
no clue what to do. Please help and also after copying the code in what do
i
do next. am sorry for silly question but please help me.

Thanks

"Yossy" wrote:

Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook
into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before.
Please
pardon my ignorance.

Thanks for your help

See also
http://www.rondebruin.nl/code.htm

You find the link to David's page also on that page


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"John Wilson" wrote in message ...
Yossy,

A good place to start would be he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Yossy" wrote in message
...
please where do I copy the code in. i opened the vb and to be honest I
have
no clue what to do. Please help and also after copying the code in what do
i
do next. am sorry for silly question but please help me.

Thanks

"Yossy" wrote:

Please I am very new to Macro. Please Help me on this one. I will really
appreciate it. Will like to copy multiple rows from different workbook
into
one sheet in a different workbook. Each row has the same headings.

How do i go about about to use macro. Again I haven't used it before.
Please
pardon my ignorance.

Thanks for your help

please i tried using this code
Sub RDB_Copy_Sheet()
Dim myFiles As Variant
Dim myCountOfFiles As Long

myCountOfFiles = Get_File_Names( _
MyPath:="C:\desktop\sample", _
Subfolders:=False, _
ExtStr:="*.xl*", _
myReturnedFiles:=myFiles)

If myCountOfFiles = 0 Then
MsgBox "No files that match the ExtStr in this folder"
Exit Sub
End If

Get_Sheet _
PasteAsValues:=True, _
SourceShName:="", _
SourceShIndex:=2, _
myReturnedFiles:=myFiles

End Sub

and I get this error, sub or function not defined

Thanks for your help.

Please read the information on the site

Download the example workbook to test the code


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Yossy" wrote in message ...
please i tried using this code
Sub RDB_Copy_Sheet()
Dim myFiles As Variant
Dim myCountOfFiles As Long

myCountOfFiles = Get_File_Names( _
MyPath:="C:\desktop\sample", _
Subfolders:=False, _
ExtStr:="*.xl*", _
myReturnedFiles:=myFiles)

If myCountOfFiles = 0 Then
MsgBox "No files that match the ExtStr in this folder"
Exit Sub
End If

Get_Sheet _
PasteAsValues:=True, _
SourceShName:="", _
SourceShIndex:=2, _
myReturnedFiles:=myFiles

End Sub

and I get this error, sub or function not defined

Thanks for your help.