hellow sir,

i need your guidence, i have a unique list in column AI. I Want to
apply auto filter in column D. for each unique items. i want to check the
no of visible rows after filtered. if it is smaller than 30 . i have to
update column J with the current year for all the sks in
the visible rows. if it is greater than 30 . i have to upadted J column
with the current year. 1/3 times of the visible rows.(ex if the visible rows
of unique items is 100, i have to updated 34 rows.) and after doing this, i
have to copy the visible rows for each unique items and save in a new folder
and save the file.

all the unique items must be saved in a new folder and
new file ok.

i will be very happy if you help me.
with regards,
harish.
mail id:

url:http://www.ureader.com/msg/103711524.aspx