This pretty much comes across as jibberish. If you really want some sample
code, you will have to much more detailed information. Here is some pseudo
code meeting your specification:

for i = lastrow to 1 step -1
if cells(i,somecolumn) = DateonSheet then
rows(i).copy Worksheets(somesheet).SpecifiedLocation
rows(i).Delete
end if
Next

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"satisha80" wrote:


hi,
i am a new user to excel vba programming.
i have a excel sheets with some fields like name ..... date...etc
if i enter date cloumn into the excel sheets then i need to delete that
row form that sheet and same row need to be inserted into another excel
sheets in a specified row
please send the necessary code for me


--
satisha80
------------------------------------------------------------------------
satisha80's Profile: http://www.excelforum.com/member.php...o&userid=34739
View this thread: http://www.excelforum.com/showthread...hreadid=545000