Bonjour,
dans ma database ci jointe, je voudrais que des qu'une date est entrée dans la colonne "AJ" de la feuille "RECAP", la macro "dem_create" s'execute. Cette macro permet de creer un fichier excel a partir d'un modele en reprenant les infos de la feuille recap.
Exemple: dans ma feuille recap, dans la colonne AJ de la ligne 4, je rentre 08-01-16. Alors excel cree un nouveau document, et que ce document reprenne les infos de la ligne 4 de ma feuille recap (vsl, ref, suppliers etc)
Voici la macro "dem create"
Sub DEM_CREATE()
Dim CALCSHEET As Workbook
Dim WSH As Worksheet
Dim IROW As Long
Set WSH = ThisWorkbook.Worksheets("RECAP")
Workbooks.Add Template:= _
"C:\Users\mciavaldini.TAMOILCY\AppData\Roaming\Microsoft\Templates\DEMURRAGE CALC SHEETS\DEM IN CALC(P).xltm"
IROW = ThisWorkbook.Worksheets("RECAP").ActiveCell.row
With ThisWorkbook.Worksheets("RECAP")
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("REF").Value = .Cells(IROW, "C").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("SUPPLIERS").Value = .Cells(IROW, "L").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("TERM_P").Value = .Cells(IROW, "M").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("VSL").Value = .Cells(IROW, "E").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("CT_DATES").Value = .Cells(IROW, "O").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("LP").Value = .Cells(IROW, "G").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("DP").Value = .Cells(IROW, "Y").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("GRADE").Value = .Cells(IROW, "F").Value
Workbooks("DEM IN CALC(P)1").Worksheets("TOL PREL ESTIM").Range("BL_DATE").Value = .Cells(IROW, "AI").Value
End With
End Sub
et voice ma macro dans la worksheet "recap"
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("AJ:AJ"), Target) Is Nothing And Range("AJ:AJ") <> "" Then
If Target.Column = 36 Then ' 36'th colums are active
Application.EnableEvents = False
Call DEM_CREATE
Application.EnableEvents = True
End If
End If
End Sub
clairement je pense mal reference la colonne......quelqu'un peut il m'eclairer?