Excel pomoč - avtomatsko kopiranje iz različnih...

ynos

ynos

Vremenko
18. jul 2007
24.416
3.805
113
davorinm.wordpress.com
Zdravo. Imam eno excelovo datoteko v katero se bo vnašalo podatke na različne sheete. Vsak sheet za posamezen oddelek.

Obenem pa bi rad imel sheet s skupno bazo, kjer bi bili ti podatki avtomatično zbrani, ko bodo osebe iz posameznih oddelkov vpisovale podatke v ločene sheete.

Mogoče kdo ve kako bi naštimal?

tnx
 
ynos

ynos

Vremenko
18. jul 2007
24.416
3.805
113
davorinm.wordpress.com
Ne bi sešteval.
smile-1.gif


Samo kopiral podatke. Se pravi po stolpcih so iste kategorije podatkov...po vrsticah pa so posamezne enote. Na vsakem sheetu so enote za posamezen oddelek, v skupni bazi pa bi imel iste kategorije podatkov po stolpcih ter skupne podatke po vrsticah za vse oddelke, da bi jih lahko s pivot tabelo enostavno primerjal oz. ločil.
 
ynos

ynos

Vremenko
18. jul 2007
24.416
3.805
113
davorinm.wordpress.com
Jeij. nisem se niti spomnil vrtilne tabele iz več virov.
zmaga.gif


Bom dodal še en stolpec "oddelek" v posameznih bazah ter vse skupaj združil v skupno pivot tabelo.
nahrung002.gif
 
ynos

ynos

Vremenko
18. jul 2007
24.416
3.805
113
davorinm.wordpress.com
Klinc. tale vrtilna je čudna. Ne rabim nikakršnih izračuno....rad bi, da zna vsak brez znanja naštelat določene filtre in da pokaže polja, ki jih jaz določim.


npr. na skupni vrtilni tabeli je filter ODDELEK...kjer izbereš ali vse oddelke skupaj ali samo posamezen oddelek. Izbrane celice pa so npr. IME, PRIIMEK, DELOVNI STAŽ, STATUS, IZOBRAZBA od 20-ih celic, ki so v bazi.

Bom kar pok kmečko naredil, če ne pa v access ruknit.
 
M

mavisam

Zelenc'
1. sep 2023
3
6
3
Hello, my name is Mavis Marian Agure from USA. I want to tell the world about a great and mighty spell called Dr. UDAMA ADA. My husband cheated on me and was no longer devoted to me and our children, when I asked him what the problem was, he told me that he had fallen out of love with me and wanted a divorce. It broke my heart so much that I cried many days and nights, and he left home without saying a word where he was going. I was doing some searching online when I saw an article about how the great and powerful Dr. UDAMA has helped many in a similar situation to mine. His email address was there, so I emailed him and told him about my problem, he said he would get back to me within 24 hours if I did everything he asked, which I did, as he asked me that on the first day to my greatest surprise my husband came home crying and begging let me forgive and accept him back he can also help you get in touch with him today; Email (udamaada@yahoo.com) Call / WhatsApp +18185329812
 
  • Ljubezen
  • Haha
Reactions: mosseero in Mr_Wolf
Za odgovor se prijavite ali registrirajte.
Na vrhu Bottom