Mataupu
Faafitauli
Fa'apea o lo'o i ai se matou laulau faigofie fa'apenei, lea e fa'atatauina ai le aofa'i o masina ta'itasi i totonu o 'a'ai se lua, ona fa'aliliuina lea o le aofa'i i euros i le fua mai le sela samasama J2.
O le fa'afitauli, afai e te kopiina le laina D2:D8 ma fua fa'atatau i se isi mea i luga o le laupepa, ona fa'asa'o ai lea e Microsoft Excel feso'ota'iga i nei fua fa'atatau, fa'anofo i se nofoaga fou ma taofi le faitau:
Galuega: kopi le laina fa'atasi ma fua fa'atatau ina ia aua ne'i suia fua fa'atatau ma tumau pea, fa'atumauina fua fa'atatau.
Metotia 1. So'oga atoatoa
Metotia 2: Fa'agata le tumau fua fa'atatau
Ina ia puipuia fua mai le suia pe a kopiina, e tatau ona e (le tumau) ia mautinoa e taofi e Excel le togafitia oi latou o ni fua. E mafai ona faia lenei mea e ala i le suiina o le fa'ailoga tutusa (=) i so'o se isi uiga e le masani ona maua i fua fa'atatau, pei o se fa'ailoga hash (#) po'o se pea o ampersand (&&) mo le taimi kopi. Mo lenei:
- Filifili le laina ma fua fa'atatau (i la matou fa'ata'ita'iga D2:D8)
- kiliki Ctrl + H i luga o le piano po'o luga o se fa'amau Fale – Saili ma Filifili – Sui (Aiga — Saili&Filifili — Sui)
- I totonu o le pusa faʻatalanoaga o loʻo faʻaalia, faʻapipiʻi mea o loʻo tatou sailia ma mea tatou te sui ai, ma totonu le faataamilosaga (Filifiliga) aua nei galo e faamanino Sa'iliga lautele - Fuafuaga. Matou te fetaomi Sui uma (Sui uma).
- Kopi le fa'ai'uga fa'atasi ma fua fa'atatau i le nofoaga sa'o:
- Sui # on = toe fa'aaoga le fa'amalama lava e tasi, toe fa'afo'i galuega i fua fa'atatau.
Metotia 3: Kopi e ala ile Notepad
O lenei metotia e sili atu le vave ma faigofie.
Oomi le alalaupapa keyboard Ctrl+Ё po o le faamau Faaali atu fua faatatau tab fomula (Formulas - Faaali formula), e ki ai le faiga siaki fua - nai lo iuga, o le a faʻaalia e sela ia fua faʻatatau e faʻatatau ai:
Kopi la matou laina D2:D8 ma faapipii i totonu o le tulaga masani Tusi:
Filifili nei mea uma na faapipii (Ctrl + A), toe kopi i luga o le laupapa (Ctrl + C) ma faapipii i luga o le laupepa i le mea e te manaʻomia:
E tumau na o le oomi le faamau Faaali atu fua faatatau (Fa'aali Fuafuaga)e toe faafoi le Excel i le tulaga masani.
Manatua: o lenei metotia i nisi taimi e le manuia i luga o laulau lavelave ma sela tuʻufaʻatasia, ae i le tele o mataupu e aoga lelei.
Metotia 4. Macro
Afai e masani ona e faia se kopi o fua faʻatatau e aunoa ma le suia o faʻamatalaga, ona talafeagai lea ona faʻaoga se macro mo lenei mea. Oomi le ala pupuu keyboard Alt + F11 po o le faamau Autu vaaia tab atinae (Atiae), fa'aofi se module fou i le lisi Fa'aofi - Module ma kopi le tusitusiga o lenei macro iina:
Sub Copy_Formulas() Dim copyRange As Range, pasteRange As Range On Error Resume Next Set copyRange = Application.InputBox("Filifili sela ma fua fa'atatau e kopi.", _ "Kopi fua fa'atatau", Default:=Filifilia.Address, Type := 8) Afai e Leai se mea kopiRange Ona Alu ese lea i lalo Seti pasteRange = Application.InputBox("Ia filifili le laina faʻapipiʻi." & vbCrLf & vbCrLf & _ "O le laina e tatau ona tutusa le lapopoa i le uluai " & vbCrLf & _ " laina o sela. e kopi." , "Copy formulas exactly", _ Default:=Selection.Address, Type:=8) If pasteRange.Cells.Count <> copyRange.Cells.Count Then MsgBox "Kopi ma faapipii laina eseese i le lapopoa!", vbExclamation, "Kopi sese " Alu i lalo Fa'ai'uga pe a fai pasteRange e leai se mea ona alu ese lea i lalo ole isi pasteRange.Formula = copyRange.Formula Fa'ai'u pe a Fa'ai'u Sub.E mafai ona e fa'aogaina le fa'amau e fa'agasolo ai le macro. macros tab atinae (Fa'atupu - Macros) po'o le ala pupuu keyboard Alt + F8. A maeʻa le faʻaogaina o le macro, o le a fai atu ia te oe e filifili le laina faʻatasi ma uluaʻi fua faʻatatau ma le faʻaofiina laina ma o le a kopiina fua faʻatatau:
- Va'ai lelei o fua fa'atatau ma fa'ai'uga i le taimi e tasi
- Aisea e manaʻomia ai le R1C1 faʻasino i fua faʻatatau Excel
- Fa'afefea ona vave su'e sela uma ma fua fa'atatau
- Meafaigaluega e kopi ai fua fa'atatau mai le PLEX fa'aopoopo