i don't know the name for this formula
i am attaching a file here
there are differet cites to whom i issued a numbers of semen straw(a pipe having sperms for cows and buffaloes to pregnent them)
now i want that
when ever i enter datail for Amritsar on sheet1
all detail of cell's in that perticular row goes to sheet2
same way
when ever i enter datail for tarn taran on sheet1
all detail of cell's in that perticular row goes to sheet3
same way
when ever i enter datail for gurdaspur on sheet1
all detail of cell's in that perticular row goes to sheet4AND so & so on................
Bookmarks