appending a row in a new sheet

[manchiraju]

hi all,

i have my data in a excel sheet and now i have to write a vba programme by which a particular columns value is checked in the entire sheetand if it corresponds our condition then the entire row has to be selected and should be appended in new row in another sheet of the work book.

so if i have a total of 5000 rows in excel sheet as data and the vlaues in a particular column which satisfy my pre condition are 1000in number, all these corresponding 1000 rows should be selected and pasted in a new sheet.....

pls help me out..........

thanking you in advance

 

[DaleWatson123321]

manchiraju,

I see no one has yet responded to your request for help.

I just returned from vacation, and in reviewing postings with no replies or resolutions, I thought I should check to see if you still need some help.

If you still require help, please advise. I will be able to provide specific help. In fact, if you wish, you could email me a small sample of your file, and I'll return it with the required modifications to extract and append the data as you described.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca