Tse ka Hare
Tlhahiso ea bothata
Re na le polokelongtshedimosetso (lenane, tafole - e bitse seo o se batlang) le tlhahisoleseding mabapi le ditefello leqepheng la Lintlha:
Mosebetsi: ka potlako hatisa rasiti ea chelete (tefo, invoice ...) bakeng sa keno efe kapa efe e lakatsehang e khethiloeng lethathamong lena. Tsamaea!
Mohato oa 1. Etsa Foromo
Leqepheng le leng la buka (ha re bitse leqephe lena foromo) theha foromo e se nang letho. U ka e etsa u le mong, u ka sebelisa liforomo tse lokiselitsoeng, tse nkiloeng, ka mohlala, ho tsoa liwebsaeteng tsa makasine ea Chief Accountant kapa websaeteng ea Microsoft. Ke na le ntho e kang ena:
Ka liseleng tse se nang letho (Account, Money, Receved from joalo-joalo) e tla fumana data ho tloha tafoleng ea tefo ho tloha leqepheng le leng - hamorao re tla sebetsana le sena.
Mohato oa 2: Ho lokisa tafole ea tefo
Pele o nka data ho tsoa tafoleng bakeng sa foromo ea rona, tafole e hloka ho ntlafatsoa hanyane. E leng, kenya kholomo e se nang letho ka letsohong le letšehali la tafole. Re tla sebelisa ho kenya label (e ke e be tlhaku ea Senyesemane "x") e khahlano le mohala oo re batlang ho kenya data ho oona foromong:
Mohato oa 3. Ho kopanya tafole le foromo
Bakeng sa puisano, re sebelisa mosebetsi VPR(VLOOKUP) - o ka bala ho eketsehileng ka eona mona. Tabeng ea rona, e le hore u kenye nomoro ea tefo e tšoailoeng "x" ho tsoa ho Data sheet ho seleng ea F9 foromong, u tlameha ho kenya foromo e latelang ka seleng ea F9:
=VLOOKUP(“x”,Data!A2:G16)
=VLOOKUP(“x”;Data!B2:G16;2;0)
Tseo. e fetoletsoeng ho "e utloisisoang", mosebetsi o lokela ho fumana moeling oa A2: G16 leqepheng la Data mola o qalang ka sebopeho "x" 'me o re fe likahare tsa kholomo ea bobeli ea mohala ona, ke hore, nomoro ea tefo.
Lisele tse ling tsohle tse foromong li tlatsitsoe ka tsela e ts'oanang - ke palo ea kholomo feela e fetohang ka foromo.
Ho hlahisa palo ka mantsoe, ke sebelisitse ts'ebetso Eena ho tsoa ho tlatsetso ea PLEX.
Sephetho e lokela ho ba se latelang:
Mohato oa 4. E le hore ho se be le "x" tse peli ...
Haeba mosebelisi a kenya "x" khahlano le mela e mengata, ts'ebetso ea VLOOKUP e tla nka feela boleng ba pele boo e bo fumanang. Ho qoba ho hlaka ho joalo, tobetsa ka ho le letona ho leqephe la leqephe Lintlha eaba Mongolo oa mohloli (Mohloli oa Mohloli). Ka fensetere ea Visual Basic editor e hlahang, kopitsa khoutu e latelang:
Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long Dim str As String If Target.Count > 1 Ebe U Tsoa Sub If Target.Column = 1 Joale str = Target.Value Application.EnableEvents = False r = Lisele(Rows.Count , 2).Qetella(xlUp).Row Range("A2:A" & r).ClearContents Target.Value = str End If Application.EnableEvents = True End Sub Macro ena e thibela mosebelisi ho kenya "x" e fetang e le 'ngoe kholomong ea pele.
Ho lokile, ke phetho! Natefeloa!
- Ho sebelisa mosebetsi oa VLOOKUP ho fetola boleng
- Mofuta o ntlafalitsoeng oa tšebetso ea VLOOKUP
- Chelete ka mantsoe (Mosebetsi oa Propis) ho tsoa ho tlatsetso ea PLEX