i need help again here...wads the code for extracting information from
sheet2 on the same file?together there are 4 sheets.
on sheet2 i need to extract the User ID fr column D8 - till the end of
the information.

do ask me again if dun understand.thanks alot.


--
ayunik
------------------------------------------------------------------------
ayunik's Profile: http://www.excelforum.com/member.php...o&userid=24317
View this thread: http://www.excelforum.com/showthread...hreadid=382681

Dim rng as Range
With Worksheets("Sheet2")
set rng = .Range(.Cells(8,"D"),.Cells(rows.count,"D").End(xl up))
End With
rng.copy Destination:=Worksheets("sheet3").Range("A1")

copies the User ID to Column 1 of sheet3 as an example.

--
Regards,
Tom Ogilvy

"ayunik" wrote in
message ...

i need help again here...wads the code for extracting information from
sheet2 on the same file?together there are 4 sheets.
on sheet2 i need to extract the User ID fr column D8 - till the end of
the information.

do ask me again if dun understand.thanks alot.


--
ayunik
------------------------------------------------------------------------
ayunik's Profile:
http://www.excelforum.com/member.php...o&userid=24317
View this thread: http://www.excelforum.com/showthread...hreadid=382681