Maitiro Ekubatanidza Excel mafaera mune imwe

Kazhinji kana uchishanda mune yeTabular mupepeti inoitika nenzira iyo ruzivo rwunodiwa rwuri pane rakaparadzaniswa masheets kana mafaera. Vashandisi vashandisi, basa rekubatanidza masheti akawanda uye mafaera kune imwe chete nhamba. Iwe unogona, hongu, nekuteedzera masero kubva kune rimwe gwaro uye ugoisa mune imwe faira kuti iite maitiro ekusanganisa, asi hazvina kunaka uye zvisina kufanira. Munyaya yacho, isu tichakurukura zvakadzama nzira dzinoverengeka dzinobudirira dzinobvumidza iwe kuti uite mashandisirwo ezvinyorwa zvidimbu zviitwe mune imwe.

Kusanganisa vashandi mune imwe muTafura mupepeti

Pakutanga, funga maitiro akadaro sekusanganisa vashandi mune rimwe gwaro. Mirayiridzo yakadzama inotaridzika seizvi:

1. Isu tinoburitsa kuvhura kwemashiti anoshanda atinoronga kusanganisa mune imwe faira.
2. Kufamba muchikamu chimwe chete chine zita rekuti "kumba". Pano mumhando yekuraira block, tinowana chinhu pasi pezita "fambisa kana kutevedzera pepa" uye tinya pairi neRuboshwe bhatani bhatani.
3. Muzvinyorwa zvakavhurika, tinya kiyi yekuruboshwe yeiyo mbeva kune iyo "(New Book) bhatani".
4. Mushure mekushandiswa kwezvese zviito, isu tinodzvanya pane "Zvakanaka".
5. Mamwe mashandiro anofanirwa kuitwa nemamwe mashiti egwaro rebhuruu.

Union yeruzivo mune imwe faira

Kazhinji pane mamiriro akadai pazvinenge zvichidikanwa kusanganisa zvimwe zvezvikamu zvezvidimbu mune imwe faira. Maitiro aya anoitwa ari nyore kushandisa iyo tafura yekuzvidza. Chinhu chinonyanya kukosha ndechekuti zviratidzo zviri muzviratidzo zvinofanirwa kuvezwa kumberi kuti mune ramangwana hazvisi kushandisa huwandu hwakakura hwenguva yekuunza chiratidzo chemuviri kune chimiro chakajairika. Mirayiridzo yakadzama inotaridzika seizvi:

1. Semuenzaniso, isu tine inotevera data iyo inofanirwa kuendeswa kune imwe faira. Maitiro ekushamwaridzana achashanda zvakanaka chete pasi pekuchengetwa kweimwe pfungwa dzinoverengeka. Mashizha anoshanda anozoita maitiro ekubatanidza anofanirwa kupihwa yunifomu fomati ine yakafanana misoro uye ruzivo mafomu. Zvese zvimwe, ruzivo rwakabatanidzwa harufanire kunge iine mitsara isina chinhu uye mbiru.

Poshi

1. Mushure mekunge taunza ruzivo kubva kune dzakasiyana nzvimbo dzebasa kune yunifomu fomati, isu tinofanirwa kuita chisikwa cheseti nyowani yekushanda. Iwe unogona kuita izvi nekutsikirira bhatani rekuruboshwe pane diki remhepo rerima rerima, iri pazasi peyema yeTafura inoenderana nemimwe masheti emamwe mashiti.

1. Pane imwe nhanho inotevera, tinoenda kuchikamu chine zita "data". Izvo zvinokwanisika kuzviwana kubva kumusoro, mune menyu huru yemubhadharo wefurafura. Pano tinowana chinhu chinonzi "kubatanidzwa", uye tinya pachiri neiyo kuruboshwe mbeva bhatani.

2.

1. Mune rondedzero yakaiswa, tinya iyo kiyi yekuruboshwe yeiyo mbeva pamusoro pezvinhu "huwandu". Tevere, isu tinopinda maironga emasero atinoronga kusanganisa.

3.

1. Zviito zvakafanana tinogadzira nerumwe ruzivo rwatinoronga kusanganisa mune imwe faira.
2. Mushure mezvose zvinodiwa zviito, isu tinodzvanya pane "ok" kuti tisimbise shanduko dzakaitwa.

ina

Kubatanidza mafaera neVBA

Macros, akarairwa muVBA, akanakisa kuita maitiro ekubatanidza akawanda magwaro mune imwe faira. Maitiro haana kuomarara, sezvazvinoratidzika pakutanga kutarisa. Chinhu chikuru ndechekutevera zvinhu zvemirayiridzo yakazara:

1. Pakutanga, iwe unofanirwa kuve nechokwadi chekuti zvese zvinodiwa magwaro anowanikwa mune imwe nzvimbo yekombuta yemunhu.
2. Pane imwe nhanho inotevera, zvinodikanwa kuti uende kuEklation's Tabular mupepeti uye gadzira bhuku idzva mukati maro, iyo ichashanda sechishandiso chekubatanidza mamwe magwaro ebular.
3. Uchishandisa kusanganiswa kwakakosha kwemakona anopisa "alt + f11", tinofamba tichiona zvinhu zvinooneka.

shanu

1. Kutanga, tinya pa "paste", uyezve mune rondedzero inoonekwa, tinya kiyi yekuruboshwe yeiyo mbeva kune iyo zita rekuti "module".
2. Iye zvino iwe unofanirwa kunyora inotevera kodhi yekodhi pano:

1. Mune iyo nzira inoshanduka inodiwa kunyora iyo nzira kunzvimbo yekombuta yemunhu, iyo ine magwaro epafura ekubatanidza.
2. Isu tinoburitsa kuponesa gwaro reTabular mu "XLLSM" fomati yekudzosera macros akagadzirwa.
3. Isu tinogadzira kutanga kwe macro.
4. Kugadzirira! Takasanganisa mafaera ese ari mufolda mune imwe tabular gwaro.

Mhedziso

Takaona kuti kune dzakawanda nzira dzekushandisa kusunganidzwa kwemafaira akawanda mune rimwe gwaro rebhuruu. Shandisa basa inonzi "Consolidation" yakakodzera chete kana mafaera aine ruzivo chete ruzivo, sezvo basa racho risingakwanisi kushanda neyemavara data nenzira kwayo. Nzira inoshanda kwazvo yekukwana magwaro eTabular mune imwe faira pasina kurasikirwa neruzivo ndeyekushandisa mutauro wakabatanidzwa "uye kuisirwa kweanoshamisa macros. Nekudaro, mushandisi wega wega achakwanisa kusarudza nzira iri nyore yekubatanidza magwaro epafura.

Mharidzo Maitiro Ekubatanidza Excel mafaera kune imwe yakatanga yekutanga kune tekinoroji yeruzivo.