Momwe mungaphatikizire mafayilo owonjezera mu

Nthawi zambiri mukamagwira ntchito yokongoletsa zimachitika m'njira yoti chidziwitso chofunikira chimapezeka pa ma sheet a ntchito kapena mafayilo. Ogwiritsa ntchito, ntchito yophatikiza matele ambiri ndi mafayilo angapo. Mutha kutero, potengera maselo kuchokera ku chikalata chimodzi ndikuyikanso fayilo ina kuti mukwaniritse njira yophatikiza, koma sizovuta komanso zosatheka. M'nkhaniyi, tikambirana mwatsatanetsatane njira zingapo zothandiza zomwe zimakupatsani mwayi wophatikiza zolemba za tebulo kukhala imodzi.

Kuphatikiza antchito mu mkonzi wa tebulo

Poyamba, taganizirani za njira ngati kuphatikiza antchito mu chikalata chimodzi. Malangizo atsatanetsatane amawoneka motere:

1. Timatulutsa ma sheet omwe timakonzekera kuphatikiza mu fayilo imodzi.
2. Kusunthira mu gawo lokhala ndi dzina "kunyumba". Pano mu mtundu wa mawonekedwe, timapeza chinthu pansi pa dzinalo "kusunthira kapena kujambulitsa ndi batani lakumanzere.
3. Pa mndandanda wotseguka, dinani batani la kumanzere kwa mbewa ku batani "(buku latsopano)".
4. Pambuyo kukhazikitsa machitidwe onse, timadina pa "Chabwino".
5. Ntchito zofananazi ziyenera kupangidwa ndi ma sheet ena a chikalata cha TAB.

Union of chidziwitso mu fayilo imodzi

Nthawi zambiri pamakhala zochitika ngati izi pakafunika kuphatikiza zidutswa zina za zidziwitso mufayilo imodzi. Njirayi imachitidwa pogwiritsa ntchito zida za tebulo. Chofunikira kwambiri ndi chidziwitso chomwe chili m'mazizindikiro chikuyenera kuti lipangidwe pasadakhale kuti mtsogolomo sizikhala nthawi yayitali kuti mubweretse chizindikiro chonse. Malangizo atsatanetsatane amawoneka motere:

1. Mwachitsanzo, tili ndi izi zomwe ziyenera kusamutsidwa ku fayilo imodzi. Njira yocheza imagwira ntchito molondola malinga ndi mfundo zina zingapo. Masamba ogwirira ntchito omwe azigwiritsa ntchito njira yogwirizira iyenera kuperekedwa ku mawonekedwe ofanana ndi mitu ofanana ndi mitundu yodziwika. China chilichonse, chidziwitso chophatikizidwa sichikhala ndi mizere yopanda tanthauzo komanso mizati.

chimodzi

1. Tikabweretsa chidziwitso kuchokera kumadera osiyanasiyana pantchito zosinthana zojambulajambula, tiyenera kukhazikitsa chilengedwe cha pepala latsopano logwira ntchito. Mutha kuchita izi pokakamiza batani lamanzere la mbewa pa Phoni laling'ono la mtundu wakuda, lomwe lili pansi pa tebulo la tebulo pafupi ndi ma tabu a ma sheet ena.

1. Pa gawo lotsatira, timasamukira ku gawo lomwe lili ndi dzina "data". Ndizotheka kuzipeza kuchokera kumwamba, mumenyu yayikulu ya mkonzi wa tebulo. Apa tikupeza chinthu chotchedwa "Kuphatikiza", ndikudina batani la mbewa.

2.

1. M'ndandanda womwe wagwiritsidwa ntchito, dinani kiyi ya kumanzere kwa mbewa pazomwezo "kuchuluka". Kenako, timalowa m'malo mwa maselo omwe timakonzekera kuphatikiza.

3.

1. Zochita zomwezi timapanga ndi zidziwitso zina zomwe timafuna kuphatikiza mu fayilo imodzi.
2. Pambuyo pazofunikira zonse, timadina "Chabwino" kuti titsimikizire zomwe zachitika.

zinai

Kuphatikiza mafayilo ndi VBA

Macros, omwe adalembedwa ku VBA, ali abwino kukhazikitsa njira yophatikiza zikwangwani zingapo. Njirayi siyovuta kwambiri, monga ikuwonekera poyamba. Chinthu chachikulu ndikutsatira zinthu zomwe zafotokozedwera:

1. Poyamba, muyenera kuonetsetsa kuti zikalata zonse zofunika kuwunika zili pamalo amodzi mwa kompyuta.
2. Pa gawo lotsatira, ndikofunikira kupita ku mkonzi wa Ekil wa Ekille ndikupanga buku latsopano mmenemo, lomwe lidzakhale chida chophatikiza zikalata zina zamiyala.
3. Pogwiritsa ntchito mitundu yapadera ya makiyi otentha "alt + F11", timasamukira.

zisanu

1. Choyamba, dinani pa "phala", kenako mu mndandanda womwe ukuwoneka, dinani kiyi ya kumanzere kwa mbewa ku chinthu "module".
2. Tsopano muyenera kulemba nambala yaying'ono apa:

1. Pakusintha ndikofunikira kulemba njira kupita kumalo a kompyuta yanu, yomwe ili ndi zikalata za tebulo.
2. Timapanga kupulumutsa chikalata chojambulidwa mu "XLSM" kuti iyambitse ma macros.
3. Timayambitsa macro.
4. Takonzeka! Tinaphatikiza mafayilo onse mufoda mu chikalata chimodzi.

Mapeto

Tidazindikira kuti pali njira zambiri zogwiritsira ntchito mafayilo angapo kukhala chikalata chimodzi. Gwiritsani ntchito ntchito yotchedwa "Kuphatikiza" kokha ngati mafayilo ali ndi chidziwitso chokhacho, chifukwa ntchitoyi siyitha kugwira ntchito ndi zolemba zolembedwa moyenera. Njira yabwino kwambiri yolumikizira zikalata za tagala mu fayilo imodzi popanda kutaya chidziwitso ndikugwiritsa ntchito chinenero cha chinenero cha "choyambirira" ndi kutsegula kwa macros apadera. Komabe, wogwiritsa ntchito aliyense amatha kusankha njira yabwino yophatikiza zikalata zamatebulo.

Mauthenga Momwe mungagwiritsire mafayilo apamwamba kwa imodzi yomwe idawonekera koyamba ku ukadaulo.