planning du mois. dur exemple budget
GESTIONUtilisez les 12 feuilles pour grer les dpenses sur 12
mois ou pour grer jusqu' 12 comptes Rcapitulatif :N de
feuilleEntresSortiesBalances(automatis)Feuille 1- 0- 0- 0Feuille 2-
0- 0- 0Feuille 32,300.00865.001,435.00Feuille 4- 0- 0- 0Feuille 5-
0- 0- 0Feuille 6- 0- 0- 0Feuille 7- 0- 0- 0Feuille 8- 0- 0-
0Feuille 9- 0- 0- 0Feuille 10- 0- 0- 0Feuille 11- 0- 0- 0Feuille
12- 0- 0-
0Moyennes2,300.00865.001,435.00Totaux2,300.00865.001,435.00LISTETypes
dfinir
:SalaireFactures(personnalisable)RetraitsSortiesSalaireAchats
diversLoterieRetraitsLoyerAchats diversCommissionsLoyerDpenses de
santCommissionsFrais de vhiculeDpenses de santAssurancesFrais de
vhiculeTlphone et internetAssurancesAutres fraisTlphone et
internetFacturesSortiesSite de l'auteur
:www.excel-pratique.comLoterie0Forum Excel
:forum.excel-pratique.com0(pour toute question, remarque,
apprciation)000Effacer le contenu des 12 feuilles :0(remise zro -
attention !!)0 2008 - Excel-pratique.com - Application modifiable
pour un usage personnel uniquement, distribution interdite 2007 -
Excel-pratique.com - Application modifiable pour un usage personnel
uniquement, distribution interdite.
Calcul de la moyenne en tenant compte uniquement des feuilles
utilises ...TOUT
EFFACERwww.excel-pratique.comforum.excel-pratique.comwww.excel-pratique.comforum.excel-pratique.com
1DateTypeDtailsEntresSortiesBalance :-
2DateTypeDtailsEntresSortiesBalance :-
3DateTypeDtailsEntresSortiesBalance :+ 14353/7/15Salaire 1Oncle
Said1,500.00- 03/7/15Poche100.00-
03/9/15Transport500.003/15/15Retrait200.003/16/15achat200.0020.003/17/15petit
dej6.003/17/15dej5.003/17/15Pain5.003/18/15Glace6.003/19/15dej15.003/19/15Salaire
2Mre500.00-
03/19/15Shampoing39.003/19/15Gel20.003/20/15Rab6.003/22/15dinner28.003/22/15dej15.00
4DateTypeDtailsEntresSortiesBalance :-
5DateTypeDtailsEntresSortiesBalance :-
6DateTypeDtailsEntresSortiesBalance :-
7DateTypeDtailsEntresSortiesBalance :-
8DateTypeDtailsEntresSortiesBalance :-
9DateTypeDtailsEntresSortiesBalance :-
10DateTypeDtailsEntresSortiesBalance :-
11DateTypeDtailsEntresSortiesBalance :-
12DateTypeDtailsEntresSortiesBalance :-
Attribute VB_Name = "Feuil2"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil1"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil4"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil3"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Module1"Sub EFFACER()Attribute
EFFACER.VB_Description = "Macro enregistre le 11.03.2007 par
Mathier"Attribute EFFACER.VB_ProcData.VB_Invoke_Func = " \n14"
Sheets("1").Select Rows("3:1002").Select Selection.ClearContents
Range("B3").Select Sheets("2").Select Rows("3:1002").Select
Selection.ClearContents Range("B3").Select Sheets("3").Select
Rows("3:1002").Select Selection.ClearContents Range("B3").Select
Sheets("4").Select Rows("3:1002").Select Selection.ClearContents
Range("B3").Select Sheets("5").Select Rows("3:1002").Select
Selection.ClearContents Range("B3").Select Sheets("6").Select
Rows("3:1002").Select Selection.ClearContents Range("B3").Select
Sheets("7").Select Rows("3:1002").Select Selection.ClearContents
Range("B3").Select Sheets("8").Select Rows("3:1002").Select
Selection.ClearContents Range("B3").Select Sheets("9").Select
Rows("3:1002").Select Selection.ClearContents Range("B3").Select
Sheets("10").Select Rows("3:1002").Select Selection.ClearContents
Range("B3").Select Sheets("11").Select Rows("3:1002").Select
Selection.ClearContents Range("B3").Select Sheets("12").Select
Rows("3:1002").Select Selection.ClearContents Range("B3").Select
Sheets("GESTION").Select ActiveWindow.SmallScroll Down:=-30End
Sub
Attribute VB_Name = "Feuil6"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil5"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil8"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil7"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil13"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil12"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil11"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil10"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "Feuil9"Attribute VB_Base =
"0{00020820-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
Attribute VB_Name = "ThisWorkbook"Attribute VB_Base =
"0{00020819-0000-0000-C000-000000000046}"Attribute
VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute
VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute
VB_TemplateDerived = FalseAttribute VB_Customizable = True
