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" <(E-Mail Removed)> wrote in message news:3767106A-8F28-496D-A83B-(E-Mail Removed)...
> 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 here:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Yossy" <(E-Mail Removed)> wrote in message
news:5DA3BA73-B909-44A3-B875-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message news:3767106A-8F28-496D-A83B-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:%23wh82$(E-Mail Removed)...
> Yossy,
>
> A good place to start would be here:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> John
>
> "Yossy" <(E-Mail Removed)> wrote in message
> news:5DA3BA73-B909-44A3-B875-(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message news:069B2F7A-A535-4E62-ACEC-(E-Mail Removed)...
> 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.

hey Ron,
I have read through the information and made necessary adjustment to the
Get_File_Names and Get _ Sheet function but I don't know what am missing as I
keep getting the same error "sub or function not defined" please help,
anybody help
and it also highlights the "Sub RDB_Copy_Sheet()" and the "Get_File_Names".
I want to believe this is where the error is coming from but have no clue as
to what to do next.

Thanks for helping out. I really appreciate it.

Do you use the example workbook ?

Show me the Sub RDB_Copy_Sheet macro

--

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


"Yossy" <(E-Mail Removed)> wrote in message news:BEA3E777-7413-4DB8-9A3C-(E-Mail Removed)...
> hey Ron,
> I have read through the information and made necessary adjustment to the
> Get_File_Names and Get _ Sheet function but I don't know what am missing as I
> keep getting the same error "sub or function not defined" please help,
> anybody help
> and it also highlights the "Sub RDB_Copy_Sheet()" and the "Get_File_Names".
> I want to believe this is where the error is coming from but have no clue as
> to what to do next.
>
> Thanks for helping out. I really appreciate it.
>