ADVERTISEMENT

Umowy2.xls

Excel-przenoszenie wyszukanych umów do poszczególnych arkuszy

Wprowadziłem zabezpieczenie żebyś dwa razy nie wprowadził tej samej umowy zarówno poprzez wprowadź jak i poprzez dodaj. Eliminuje przypadkowe powtórne naciśnięcie przycisku. Na marginesie na forum jak jesteś wdzięczny to wciskasz pod daną wypowiedzią "pomógł". :)


Download file - link to post

" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " E/G/001/2000 " , " K001 " , " Kozie? Marian " ,,, " 01-01-04 " ,, " G12kPR " , " 1 " , " 10 " , " D " , " 2.3.2. " , " 4C52cd " , " 10450236 " , " 1/1 " , " 1/1 " , " G12kPR " , " G "
" 2 " , " E/G/003/2000 " , " B003 " , " Berg Arkadiusz " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 4.1.1. " , " C52d " , " 11132996 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 3 " , " E/G/004/2000 " , " W004 " , " W?odarczyk Bogus?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 11.5 " , " D " , " 3.8.3. " , " C52d " , " 11120828 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 4 " , " D/Z/1/2012 " , " E321 " , " Energomonta? " ,,, " 09-01-12 " ,, " C21z " , " 1 " , " 140 " , " M " , " ST-11 sek. 1 pole 1.15 " , " EABM " , " 8250000426 " , " 150/5 " , " 1/1 " , " C21z " , " C "
" 5 " , " E/G/010/2002 " , " W010 " , " Wengrzy?ski Ryszard " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 24 " , " D " , " 3.3.2. " , " C52d " , " 11131576 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 6 " , " E/G/011/2000 " , " G011 " , " Gregorczyk Mieczys?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 2.3.2. " , " C52d " , " 11130774 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 7 " , " E/G/012/2000 " , " P012 " , " Podsiad?y Pawe? " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 4 " , " D " , " 3.7.3. " , " 4C52d " , " 11120824 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 8 " , " E/G/013/2000 " , " P013 " , " Paszkowski Jan " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 3.5.4. " , " C52d " , " 11132998 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 9 " , " E/G/014/2001 " , " I014 " , " Juszczak Bogus?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 10 " , " D " , " 1.2.1. " , " C52d " , " 11336961 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 10 " , " E/I/086/2000 " , " B086 " , " B?aszczyk Kazimierz " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 6 " , " D " , " 3.8.1. " , " 4C52d " , " 11535333 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 11 " , " s/I/090/2000 " , " D090 " , " Dziubo? Marek " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 4.5 " , " D " , " 2.3.4. " , " 4C52d " , " 11536273 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 12 "
" 13 " , " E/I/127/2003 " , " B027 " , " Bary?a Jacek " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 12 " , " D " , " 1.1.2. " , " 6C8d " , " 12470703 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 14 " , " E/I/161/2005 " , " K061 " , " Ko?ba Piotr " ,,, " 01-24-05 " ,, " C11ik " , " 1 " , " 3 " , " D " , " 2.6.1. " , " 6C8d " , " 12981088 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 15 " , " E/I/174/2005 " , " K043 " , " Ka?mierczak S?awomir " ,,, " 05-11-05 " ,, " C11ik " , " 1 " , " 9 " , " D " , " 6.5.4. " , " 6C8d " , " 13062405 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 16 " , " E/G/002/2000 " , " I002 " , " Jab?o?ska-Bielecka Ma?gorzata " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 3.2.3. " , " C52d " , " 11133000 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 17 " , " D/Z/10/2012 " , " B60 " , " Bin? " ,,, " 09-01-12 " ,, " C21z " , " 1 " , " 50 " , " M " , " ST-15 sek. 2 pole 8.13 " , " EABM " , " 8250001066 " , " 100/5 " , " 1/1 " , " C21z " , " C "
" 18 " , " E/Z/618//12011 " , " s302 " , " SKB Sp. z o.o. Spó?ka Komandytowa " ,,, " 08-04-11 " ,, " C21z " , " 1 " , " 120 " , " M " , " ST/24 s. I p. 5.8. " , " EABM " , " 8250000435 " , " 200/5 " , " 1/1 " , " C21z " , " C "
" 19 " , " E/Z/625/1/2012 " , " P232 " , " PSE Sp. z o.o. " ,,, " 07-01-12 " ,, " C11z " , " 1 " , " 20 " , " M " , " budynek BTS na zapleczu Instal " , " sEA " , " 5030006459 " , " 75/5 " , " 1/1 " , " C11z " , " C "
" 20 " , " E/Z/819/2012 " , " B147 " , " Babcock Borsig Steinmuller " ,,, " 01-09-12 " ,, " C21z " , " 1 " , " 100 " , " M " , " ST-25 sek.2 p.4.1 " , " sEA " , " 503-0006494 " , " 300/5 " , " 1/1 " , " C21z " , " C "
" 21 " , " E/G/005/2000 " , " S005 " , " Szulc Roman " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 10 " , " D " , " 4.1.2. " , " C52d " , " 11120823 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 22 " , " E/I/006/2000 " , " S006 " , " Rombud-Handel Szulc Roman " ,,, " 01-01-04 " ,, " C11k " , " 1 " , " 12 " , " D " , " 4.1.2. " , " C52d " , " 11120829 " , " 1/1 " , " 1/1 " , " C11k " , " C "
" 23 " , " E/I/023/2000 " , " T023 " , " Teslar Robert " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 3.4.1. " , " 4C52d " , " 11319035 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 24 " , " E/I/083/2000 " , " L083 " , " Lasota Zbigniew " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 1.1.5. " , " 4C52d " , " 11535315 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 25 " , " E/I/085/2000 " , " K085 " , " Komorowski Andrzej " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 1.8.3. " , " 4C52d " , " 11536252 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " E/G/001/2000 " , " K001 " , " Kozie? Marian " ,,, " 01-01-04 " ,, " G12kPR " , " 1 " , " 10 " , " D " , " 2.3.2. " , " 4C52cd " , " 10450236 " , " 1/1 " , " 1/1 " , " G12kPR " , " G "
" 2 " , " E/G/003/2000 " , " B003 " , " Berg Arkadiusz " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 4.1.1. " , " C52d " , " 11132996 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 3 " , " E/G/004/2000 " , " W004 " , " W?odarczyk Bogus?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 11.5 " , " D " , " 3.8.3. " , " C52d " , " 11120828 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 4 " , " E/G/010/2002 " , " W010 " , " Wengrzy?ski Ryszard " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 24 " , " D " , " 3.3.2. " , " C52d " , " 11131576 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 5 " , " E/G/011/2000 " , " G011 " , " Gregorczyk Mieczys?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 2.3.2. " , " C52d " , " 11130774 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 6 " , " E/G/012/2000 " , " P012 " , " Podsiad?y Pawe? " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 4 " , " D " , " 3.7.3. " , " 4C52d " , " 11120824 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 7 " , " E/G/013/2000 " , " P013 " , " Paszkowski Jan " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 3.5.4. " , " C52d " , " 11132998 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 8 " , " E/G/014/2001 " , " I014 " , " Juszczak Bogus?aw " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 10 " , " D " , " 1.2.1. " , " C52d " , " 11336961 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 9 " , " E/G/002/2000 " , " I002 " , " Jab?o?ska-Bielecka Ma?gorzata " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 7.5 " , " D " , " 3.2.3. " , " C52d " , " 11133000 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" 10 " , " E/G/005/2000 " , " S005 " , " Szulc Roman " ,,, " 01-01-04 " ,, " G11k3 " , " 1 " , " 10 " , " D " , " 4.1.2. " , " C52d " , " 11120823 " , " 1/1 " , " 1/1 " , " G11k3 " , " G "
" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " E/I/086/2000 " , " B086 " , " B?aszczyk Kazimierz " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 6 " , " D " , " 3.8.1. " , " 4C52d " , " 11535333 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 2 " , " E/I/127/2003 " , " B027 " , " Bary?a Jacek " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 12 " , " D " , " 1.1.2. " , " 6C8d " , " 12470703 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 3 " , " E/I/161/2005 " , " K061 " , " Ko?ba Piotr " ,,, " 01-24-05 " ,, " C11ik " , " 1 " , " 3 " , " D " , " 2.6.1. " , " 6C8d " , " 12981088 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 4 " , " E/I/174/2005 " , " K043 " , " Ka?mierczak S?awomir " ,,, " 05-11-05 " ,, " C11ik " , " 1 " , " 9 " , " D " , " 6.5.4. " , " 6C8d " , " 13062405 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 5 " , " E/I/006/2000 " , " S006 " , " Rombud-Handel Szulc Roman " ,,, " 01-01-04 " ,, " C11k " , " 1 " , " 12 " , " D " , " 4.1.2. " , " C52d " , " 11120829 " , " 1/1 " , " 1/1 " , " C11k " , " C "
" 6 " , " E/I/023/2000 " , " T023 " , " Teslar Robert " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 3.4.1. " , " 4C52d " , " 11319035 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 7 " , " E/I/083/2000 " , " L083 " , " Lasota Zbigniew " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 1.1.5. " , " 4C52d " , " 11535315 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 8 " , " E/I/085/2000 " , " K085 " , " Komorowski Andrzej " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 10 " , " D " , " 1.8.3. " , " 4C52d " , " 11536252 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " D/Z/1/2012 " , " E321 " , " Energomonta? " ,,, " 09-01-12 " ,, " C21z " , " 1 " , " 140 " , " M " , " ST-11 sek. 1 pole 1.15 " , " EABM " , " 8250000426 " , " 150/5 " , " 1/1 " , " C21z " , " C "
" 2 " , " D/Z/10/2012 " , " B60 " , " Bin? " ,,, " 09-01-12 " ,, " C21z " , " 1 " , " 50 " , " M " , " ST-15 sek. 2 pole 8.13 " , " EABM " , " 8250001066 " , " 100/5 " , " 1/1 " , " C21z " , " C "
" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " E/Z/618//12011 " , " s302 " , " SKB Sp. z o.o. Spó?ka Komandytowa " ,,, " 08-04-11 " ,, " C21z " , " 1 " , " 120 " , " M " , " ST/24 s. I p. 5.8. " , " EABM " , " 8250000435 " , " 200/5 " , " 1/1 " , " C21z " , " C "
" 2 " , " E/Z/625/1/2012 " , " P232 " , " PSE Sp. z o.o. " ,,, " 07-01-12 " ,, " C11z " , " 1 " , " 20 " , " M " , " budynek BTS na zapleczu Instal " , " sEA " , " 5030006459 " , " 75/5 " , " 1/1 " , " C11z " , " C "
" 3 " , " E/Z/819/2012 " , " B147 " , " Babcock Borsig Steinmuller " ,,, " 01-09-12 " ,, " C21z " , " 1 " , " 100 " , " M " , " ST-25 sek.2 p.4.1 " , " sEA " , " 503-0006494 " , " 300/5 " , " 1/1 " , " C21z " , " C "
" 4 " , " E/Z/81w9/2012 " , " B147 " , " Babcock Borsig Steinmuller " ,,, " 01-09-12 " ,, " C21z " , " 1 " , " 100 " , " M " , " ST-25 sek.2 p.4.1 " , " sEA " , " 503-0006494 " , " 300/5 " , " 1/1 " , " C21z " , " C "
" Lp. " , " Numer Umowy " , " Kontrahent " , " Nazwa " , " Adres zameldowania " , " Adres Korespondencyjny " , " Data rozpocz?cia " , " Data zako?czenia " , " Taryfa " , " Liczba Uk?adów Pom. " , " Moc Umowna " , " Symbol Okresu R. " , " Przy??cze " , " Typ licznika " , " Numer licznika " , " Przek?. pr?dowa " , " Przek?. napi?ciowa " , " Taryfa " , " Typ taryfy "
" 1 " , " s/I/090/2000 " , " D090 " , " Dziubo? Marek " ,,, " 01-01-04 " ,, " C11ik " , " 1 " , " 4.5 " , " D " , " 2.3.4. " , " 4C52d " , " 11536273 " , " 1/1 " , " 1/1 " , " C11ik " , " C "
" 2 "
" 3 " , " wefwef "
" 4 " , " wefwef "
" 5 " , " wqeqw "