hey hi vijay,
dats work gr8 i want exactly what u sent can u plz tell me how u did this
i think u used VBA but i m not familiar with dat can u plz explain
Thanx
Sudeep
Hi Narayan
Thax for quick response.
I want values to be copied not the formulas.
when i enter Pass or fail i want all the info of student to be copied in respective sheet
Sudeep
Thanx Fred, Thanx Narayan
Plz refer my uploaded file
https://hotfile.com/dl/152513804/7aae534/Sample_worksheet.xlsx.html
i dont want to copy by using filter is their any formula that cell automatically copied to another table or sheet
Sudeep
Hi,
I want to sort data in two different sheets automatically
eg. If i have three sheets 1) Total Students 2) pass student 3) fail student
in first sheet i will write info like sr.no / Name / address / other info and pass or fail
and i want to enter all info automatically to other 2 sheets...