On Jun 26, 12:06*pm, "Ron de Bruin" wrote:
Maybe this will helphttp://www.rondebruin.nl/copy1.htm

See the last example
"What if the Database sheet is in another workbook"

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Bull" wrote in ...
How would I take the data and send it to the sheet called log in a
whole different workbook located at c:\text.xls * ...

Right now, I have the data goign to a sheet called log in the same
workbook ...:

Sub test()
*With Worksheets("LOG")
* *.Cells(Rows.Count, 1).End(xlUp)(2).Value = _
* * * *Worksheets("Waiver Brief Sheet").Range("FULLNAME").Value
* *.Cells(Rows.Count, 2).End(xlUp)(2).Value = _
* * * *Worksheets("Waiver Brief Sheet").Range("DEPT").Value
* *.Cells(Rows.Count, 3).End(xlUp)(2).Value = _
*End With
End Sub

Thanks... bull- Hide quoted text -

- Show quoted text -

Ron, great info, I figured out how to transfer FULLNAME ; What if I
have multpile ranges to transfer i.e. FULLNAME, DEPT, etc....

Separate code for each, how?

Thanks Bull