Indlela yokudala ifomu ku-Excel

Ngokuvamile, abasebenzisi bomhleli wespredishithi babhekana nomsebenzi onjengokwenza ifomu elikhethekile lokufaka ulwazi oludingekayo. Amafomu ayifomu elisiza ukwenza lula inqubo yokugcwalisa idokhumenti yesipredishithi. Umhleli unethuluzi elihlanganisiwe elikuvumela ukuthi ugcwalise ishidi lokusebenzela ngale ndlela. Ngaphezu kwalokho, umsebenzisi wohlelo, esebenzisa i-macro, angakha inguqulo yakhe yefomu, eguqulelwe emisebenzini ehlukahlukene. Esihlokweni, sizocubungula ngokuningiliziwe izindlela ezahlukahlukene ezikuvumela ukuthi udale ifomu kudokhumenti yesipredishithi.

Ukusebenzisa amathuluzi okugcwalisa kusihleli sespredishithi

Ifomu lokugcwalisa liyisici esikhethekile esinezinkambu amagama azo ahambisana namagama amakholomu epuleti eligcwaliswayo. Kudingekile ukushayela ngolwazi emasimini, okuzofakwa ngokushesha njengomugqa omusha endaweni ekhethiwe. Lesi simo esikhethekile singasetshenziswa njengethuluzi lesipredishithi esihlanganisiwe esizimele sodwa noma singatholakala ekhasini lokusebenza ngokwalo njengobubanzi. Ake sihlaziye ukwahluka ngakunye ngokuningiliziwe.

Indlela yokuqala: into ehlanganisiwe yokufaka ulwazi

Ake siqale sithole ukuthi singalisebenzisa kanjani ifomu elihlanganisiwe ukuze sengeze ulwazi kudokhumenti yesipredishithi somhleli. Imiyalelo enemininingwane ibukeka kanje:

1. Qaphela ukuthi ekuqaleni, isithonjana esifaka leli fomu siyafihlwa. Kudingeka senze inqubo yokuvula ithuluzi. Sithuthela kumenyu engaphansi "Yefayela", etholakala engxenyeni engenhla kwesokunxele yesixhumi esibonakalayo somhleli wespredishithi. Lapha sithola into enegama elithi “Parameters”, bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

2. Iwindi elibizwa ngokuthi "Izinketho ze-Excel" livele esibukweni. Sidlulela esigatshaneni esithi “Iphaneli yokufinyelela Ngokushesha”. Kunezinhlobonhlobo zezilungiselelo lapha. Ngakwesobunxele kukhona amathuluzi akhethekile angenziwa asebenze kubha yamathuluzi, futhi ngakwesokudla kukhona amathuluzi asevele afakiwe. Nweba uhlu eduze nombhalo othi “Khetha imiyalo kokuthi:” bese ukhetha into ethi “Imiyalo kuribhoni” ngenkinobho yegundane engakwesokunxele. Ohlwini lwemiyalo ekhonjiswe ngokulandelana kwezinhlamvu, sibheka into ethi “Ifomu …” bese siyikhetha. Chofoza "Engeza".

3. Sichofoza inkinobho ethi "OK".

4. Senze lasebenza leli thuluzi kuribhoni ekhethekile.

5. Manje sidinga ukuqala ukuklama unhlokweni wepuleti, bese ufaka izinkomba ezithile kuwo. Ithebula lethu lizoba namakholomu angu-4. Sishayela ngamagama.

6. Siphinde sishayele ngenani elithile singene kulayini wokuqala wepuleti lethu.

7. Sikhetha noma iyiphi inkambu yepuleti elilungisiwe bese uchofoza into ethi “Ifomu …” etholakala kubhebhoni lamathuluzi.

8. Iwindi lezilungiselelo zamathuluzi liyavuleka. Nansi imigqa ehambisana namagama amakholomu epuleti.

Kuyaqapheleka ukuthi umugqa wokuqala usuvele ugcwele idatha, njengoba sike sazifaka thina ekhasini lokusebenza.

9. Sishayela ngezinkomba esizibheka njengezibalulekile emigqeni esele. Chofoza inkinobho ethi "Engeza".

10. Izinkomba ezifakiwe zadluliselwa ngokuzenzakalelayo emgqeni we-1 wetafula, futhi efomini ngokwalo, ukuguqulwa kwenziwa kwelinye ibhulokhi lamasimu elihambisana nomugqa we-2 wetafula.

11. Sigcwalisa iwindi lamathuluzi ngezinkomba esifuna ukuzibona emgqeni wesi-2 wepuleti. Sichofoza "Engeza".

12. Izinkomba ezifakiwe zadluliselwa ngokuzenzakalelayo emgqeni wesi-2 wepuleti, futhi efomini ngokwalo, ukuguqulwa kwenziwa kwelinye ibhulokhi lamasimu ahambisana nomugqa wesi-3 wepuleti.

13. Ngendlela efanayo, sigcwalisa ipuleti nazo zonke izinkomba ezidingekayo.

14. Usebenzisa izinkinobho "Okulandelayo" kanye "Emuva", ungazulazula ezinkomba ezifakwe ngaphambilini. Okunye yibha yokuskrola.

15. Uma uthanda, ungahlela noma yiziphi izinkomba etafuleni ngokuzilungisa ngendlela ngokwayo. Ukuze ulondoloze izinguquko zakho, chofoza okuthi "Engeza".

16. Siyaqaphela ukuthi wonke amanani ahleliwe aboniswa epuletini ngokwalo.

17. Ngokusebenzisa inkinobho ethi "Susa", ungasebenzisa ukususwa komugqa othize.

18. Ngemva kokuchofoza, iwindi eliyisixwayiso elikhethekile lizovela, elibonisa ukuthi umugqa okhethiwe uzosuswa. Kufanele uchofoze "OK".

19. Ulayini ususiwe etafuleni. Ngemuva kokuthi zonke izinqubo zenziwe, chofoza into ethi "Vala".

20. Ukwengeza, ungayifometha ukuze ipuleti lithole ukubukeka okuhle.

Indlela yesibili: ukugcwalisa amafomu ngolwazi oluvela kuthebhulethi

Ngokwesibonelo, sinepuleti eliqukethe ulwazi ngezinkokhelo.

Inhloso: ukugcwalisa ifomu ngale datha ukuze liphrinteke kalula futhi ngendlela efanele. Imiyalelo enemininingwane ibukeka kanje:

1. Eshidini elihlukile ledokhumenti, sakha ifomu elingenalutho.

Kuyaqapheleka ukuthi ukubukeka kwefomu ngokwalo kungadalwa ngokuzimela noma ungalanda amafomu esenziwe ngomumo emithonjeni ehlukahlukene.

2. Ngaphambi kokuthatha ulwazi epuletini, udinga ukulishintsha kancane. Sidinga ukwengeza ikholomu engenalutho kwesokunxele sethebula lokuqala. Lapha kuzobekwa uphawu eduze komugqa esihlela ukuwengeza efomini ngokwalo.

3. Manje sidinga ukusebenzisa ukubopha kwepuleti kanye nefomu. Ukuze senze lokhu, sidinga opharetha we-VLOOKUP. Sisebenzisa le fomula: =I-VLOOKUP(“x”,Idatha!A2:G16).

4. Uma ubeka uphawu eduze kwemigqa eminingana, u-opharetha we-VLOOKUP uzothatha inkomba yokuqala kuphela etholiwe. Ukuze uxazulule le nkinga, udinga ukuchofoza kwesokudla kusithonjana seshidi ngepuleti lomthombo bese uchofoza into ethi "Umbhalo womthombo". Ewindini elivelayo, faka ikhodi elandelayo:

I-Private Sub Worksheet_Change (ByVal Target As Range)

Dim r As Long

Dim str Njengeyunithi yezinhlamvu

Uma I-Target.Count > 1 Bese Uphuma Kwangaphansi

If Target.Ikholomu = 1 Bese

str = Ithagethi.Value

Application.EnableEvents = Amanga

r = Amaseli(Imigqa.Count, 2).End(xlUp).Umugqa

Ibanga(«A2:A» & r).SulaOkuqukethwe

Ithagethi.Value = ingxenye

Qeda Uma

Application.EnableEvents = Iqiniso

Qeda i-Sub

5. Le makhro ayikuvumeli ukuthi ufake ilebula engaphezu kweyodwa kukholamu yokuqala.

Isiphetho neziphetho mayelana nokudalwa kwefomu.

Sithole ukuthi kunezinhlobo ezimbalwa zokudala ifomu kusihleli sespredishithi. Ungasebenzisa amafomu akhethekile atholakala eteyiphu yamathuluzi, noma ungasebenzisa u-opharetha we-VLOOKUP ukudlulisa ulwazi kusuka epuletini kuya efomini. Ukwengeza, kusetshenziswa ama-macros akhethekile.