Kuze kube manje, ngezinye izikhathi ngokumomotheka ngikhumbula okunye kokuqeqeshwa kwami kokuqala kwezinkampani eminyakeni eyi-10 edlule.
Cabanga nje: ihhovisi elivulekile lehhovisi elimele inkampani yamazwe ngamazwe ye-FMCG, elikhulu njengenkundla yebhola. Idizayini ebukekayo, izinto zokusebenza ezibizayo zasehhovisi, ikhodi yokugqoka, izihambi ezikhala emakhoneni - yilokho kuphela 🙂 Kwelinye lamagumbi omhlangano, ngiqala ukuqeqeshwa okuthuthukisiwe kwezinsuku ezimbili kunguqulo yamanje ye-Excel 2003 yezisebenzi ezibalulekile eziyi-15 zomnyango wezomnotho. , kanye nomholi wabo. Siyajwayelana, ngibabuza ngemisebenzi yebhizinisi, izinkinga, ngibacela ukuthi babonise amafayela amaningana omsebenzi ajwayelekile. Bakhombisa ubude bekhilomitha bokulayisha kusuka ku-SAP, amaphepha emibiko abawenzayo ngalokhu, njll. Phela, kuyinto evamile - ngithola ngengqondo izihloko kanye nesikhathi, ngijwayele izethameli. Ekhoneni leso lami, ngibona ukuthi omunye wabahlanganyeli, ebonisa ucezu lombiko wakhe, edonsa ngesineke iseli ngefomula phansi ngesiphambano esimnyama ekhoneni elingezansi kwesokudla imigqa eyizinkulungwane ezimbalwa, bese weqa ukuphela itafula empukaneni, iyidonsele emuva, njll. Ngingakwazi ukukumela, ngimphazamise egoqa igundane esikrinini futhi ngibonise ukuchofoza kabili esiphambanweni esimnyama, echaza ngokuqedela okuzenzakalelayo phansi kuze kube sekupheleni.
Kusenjalo ngibone ukuthi izethameli zithule ngokusolisayo futhi wonke umuntu ungibhekile ngendlela exakile. Ngiqalaza ngokungabonakali noma kuphi lapho ngikwazi khona - konke kulungile, izingalo zami nemilenze kusendaweni, impukane yami ifakwe izinkinobho. Ngibuyisela emuva engqondweni amazwi ami okugcina ngifuna isigatshana somthetho esibi - kwakungekho lutho lobugebengu, kubonakala sengathi. Ngemva kwalokho, inhloko yeqembu iyasukuma buthule, ingixhawule futhi ithi ngobuso betshe: “Ngiyabonga, Nikolai. Lokhu kuqeqeshwa kungaqedwa.
Nokho, ngamafuphi, kwavela ukuthi akekho kubo owayenolwazi ngokuchofoza kabili esiphambanweni esimnyama nokuqedela ngokuzenzakalela. Kwenzeka ngandlela thize ngokomlando ukuthi akekho owayezobakhombisa into elula kodwa edingekayo. Umnyango wonke ukhiphe amafomula ngesandla ezinkulungwane zemigqa, abantu abampofu. Futhi ngilapha. Uwoyela scene. Inhloko yomnyango yabe isicela kakhulu ukuthi igama lenkampani yabo lingavezi muntu 🙂
Izikhathi eziningana kamuva kwaba nezimo ezifanayo, kodwa kuphela ngabalaleli ngabanye - iningi manje, yiqiniso, liyawazi lo msebenzi.
Umbuzo uhlukile. Ngemuva kwenjabulo yokuqala yokuthola lesi sici esihle kangaka, abasebenzisi abaningi baqonda ukuthi ukukopishwa okuzenzakalelayo kwamafomula ngokuchofoza kabili esiphambanweni esimnyama (umaka wokuqedela ngokuzenzakalela) kunazo zonke izici ezinhle nezingezinhle:
- Ukukopisha akwenzeki njalo ekupheleni kwetafula. Uma ithebula lingelona i-monolithic, okungukuthi kunamaseli angenalutho kumakholomu aseduze, akulona iqiniso ukuthi ukuqedela ngokuzenzakalela kuzosebenza kuze kube sekupheleni kwetafula. Ngokunokwenzeka, inqubo izoma esitokisini esingenalutho esiseduze ngaphambi kokufinyelela ekugcineni. Uma kukhona amaseli athathwe okuthile ngezansi kwekholomu, ukuqedela ngokuzenzakalela kuzoma kuwo ngqo.
- Uma ukopisha ukwakhiwa kwamaseli kumosha, ngoba Ngokuzenzakalelayo, akukopishwa ifomula kuphela, kodwa nefomethi. Ukuze ulungise, chofoza inkinobho yezinketho zokukopisha bese ukhetha Amanani kuphela (Gcwalisa ngaphandle kwefomethi).
- Ayikho indlela esheshayo futhi elula yokwelula ifomula hhayi phansi kodwa kwesokudlangaphandle kokudonsa ngesandla. Ukuchofoza kabili esiphambanweni esimnyama kuvele kuphansi.
Ake sizame ukulungisa lezi ziphutha nge-macro elula.
Cindezela isinqamuleli sekhibhodi kwesokunxele I-Alt + F11 noma inkinobho Visual Basic ithebhu Unjiniyela (Unjiniyela). Faka imojuli entsha engenalutho ngemenyu Faka – Imojula bese ukopisha umbhalo wala makhro lapho:
I-Sub SmartFillDown() Dim rng Njengobubanzi, n Isethi Eside rng = ActiveCell.Offset(0, -1).CurrentRegion Uma rng.Cells.Count > 1 Bese n = rng.Amaseli(1).Umugqa + rng.Imigqa. Bala - ActiveCell.Row ActiveCell.AutoFill Destination:=ActiveCell.Resize(n, 1), Type:=xlFillValues End If End Sub Sub SmartFillRight() Dim rng Njengobubanzi, n As Long Set rng = ActiveCell.Offset(-1, 0).Isifunda Samanje Uma rng.Amaseli.Bala > 1 Bese n = rng.Amaseli(1).Ikholomu + rng.Ikholomu.Count - ActiveCell.Column ActiveCell.AutoFill Destination:=ActiveCell.Resize(1, n), Type: =xlFillValues End if End Sub
Amamakhro anjalo:
- ayikwazi ukugcwalisa kuphela (i-SmartFillDown), kodwa futhi kwesokudla (SmartFillRight)
- ungamoshi ifomethi yamaseli angezansi noma kwesokudla - ifomula kuphela (inani) elikopishiwe
- amaseli aseduze angenalutho awanakwa futhi ukukopishwa kwenzeka ncamashi ekupheleni kwethebula, futhi hhayi esikhaleni esiseduze sedatha noma iseli lokuqala elimatasa.
Ukuze kube lula, unganikeza izinqamuleli zekhibhodi kulawa makhro usebenzisa inkinobho Amakhrosi - Izinketho (Amakhrosi - Izinketho) khona lapho kuthebhu. Unjiniyela (Unjiniyela). Manje kuzokwanela ukufaka ifomula oyifunayo noma inani kuseli lokuqala lekholomu bese ucindezela inhlanganisela yokhiye eshiwo ukuze i-macro igcwalise ngokuzenzakalelayo yonke ikholomu (noma umugqa):
Ubuhle.
PS Ingxenye yenkinga yokukopisha amafomula kuze kube sekugcineni kwetafula yaxazululwa ku-Excel 2007 ngokufika “kwamatafula ahlakaniphile”. Yiqiniso, azifaneleki ngaso sonke isikhathi futhi azifaneleki yonke indawo. Futhi kwesokudla, i-Excel ayizange ifunde ukukopisha iyodwa.
- Ayini ama-macros, asetshenziswa kanjani, ungayithola kuphi ikhodi ye-Visual Basic nokuthi uyinamathisele kuphi.
- Amathebula ahlakaniphile ku-Excel 2007-2013
- Kopisha amafomula ngaphandle kokushintshwa kwesixhumanisi