problem in deleting and inserting a row
 

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

problem in deleting and inserting a row
 

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