Obracunski List — Gradevinske Knjige Excel

Close VBA editor. Go to Developer Tab → Insert → Form Controls → Button.

Sub ResetirajList() ' Clears all data rows except headers and formulas Dim answer As VbMsgBoxResult answer = MsgBox("Obrisati sve podatke? (formule ostaju)", vbYesNo + vbQuestion, "Potvrda") If answer = vbYes Then Rows("3:100").ClearContents Range("A3").Select MsgBox "List je resetiran. Formule u stupcima G i I ostaju." End If End Sub

| A | B | C | D | E | F | G | H | I | |---|---|---|---|---|---|---|---|---| | RB | Datum | Opis rada / materijala | Jedinica mjere | Količina | Jed. cijena (€) | Ukupno (€) | PDV (%) | Iznos sa PDV | obracunski list gradevinske knjige excel

A105: "Datum izdavanja:" B105: (manual entry)

Enter these headers in :

A102: "Ukupno bez PDV:" B102: =SUM(G:G) A103: "PDV (25%):" B103: =B102*0.25

Since I cannot directly send you an .xlsx file, I will provide you with and the exact column structure to build this professional tool yourself in 2 minutes. Close VBA editor

Obračunski_list_građevinske_knjige_v1.xlsm (enable macros) If you want, I can also generate a that works exactly like Excel in your browser, or I can refine the VBA for automatic cumulative totals from multiple sheets (građevinska knjiga → obračunski list). Just let me know.