help me to solve this issue
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
(suppose sheet 2 is reserved for a indiviual account for amritsar)
same way
when ever i enter datail for tarn taran on sheet1
all detail of cell's in that perticular row goes to sheet3
(suppose sheet 3 is reserved for a indiviual account for TARN TARAN)
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................
i don't know the name for this formula.plz help me ............
Attachment | Size |
---|---|
plz help.xlsx | 40.3 KB |
If you, for example, want
If you, for example, want cell A8 on Sheet2 to be automatically updated when cell B12 on Sheet1 is updated, enter
=Sheet1!B12
in cell A8 on Sheet2. It's as simple as that.
Hope that helps.