auto update

[rajagopal]

The details i enter in particular range of a master excel file should be updated automatically in another excel file.
This file should be saved as different file and the master file should be blank.
Please find the attached file for details.

[rajagopal]

See my requirements given as comments in the attached file.

[lucas]

I think this would be easier to do in Word. Set the template up and it never changes...each new file is cloned from the template and you can save it with the name you want.

Also your extensive use of merged cells would complicate any vba. Try to avoid using merged cells. Use center across selection instead.

[rajagopal]

The data in cell range C60:L69 has to be updated in another file automatically. Here, there's no merged cells.

I want to reduce the manual effort that's why i need these functions to be executed automatically.
I had the tempalte in word earlier but faced difficulty in formatting. I prefer excel.
Can this be done in excel itself if not i provide a template in Word.

[zv735]

1. you must key "Project ID" and else...
2. you close file with out save it will automatic save file in
"MOM_(Project ID).xls
3. file MOM.xls is Emty as Original File

Thank you

See Att File.

[rajagopal]

This is fine for Saving the file.
My primary requirement is data updated in Description field (D6069), Responsibility field (J60:J69), Target date field (L60:L69) in MOM.xls has to be udpated automatically in a excel file (say the file name as Action.xls)
Each time, the user will use the MOM.xls template and the above code will save the file when user updates data in cell D8.
The action items entered in the above range should be saved in Action.xls.
Likewise, each and every time, the items entered in the above range should be saved next below to the previous update in Action.xls

Please help

[zv735]

it will save every time when u change at inputrange in file action_date_Time.xls

see att file

[rajagopal]

The target cell is not D8. It is D60:D69.
When the user updates the field D60:D69, the updates have to be updated in Action item tracker.xls
For ex. when user updates field D60:68, the same have to be updated in Action item tracker.xls in the range I7:I16 and a notification to the user that Action item tracker.xls is updated.
Next time, when the user updates new MOM template for another minutes of meeting in the cell range D60:64, the same has to be updated in Action item tracker.xls in the range I17:I21 i.e. start from the next row of previous update's final row.

Hope, i'm not confusing you.
See the attached Action item tracker.xls for reference

[rajagopal]

I don't need the file to be saved for each and every cell update.
Instead, it should save only when the cell D69 is updated.

[zv735]

please,see att file

[rajagopal]

The values i update in MOM.xls is populated on Action item tracker.xls in the same row i.e. overwrite the previous update in the same row.
It should update it in next rows.
See the attached file with my requriements (given as comment).

Please help asap.

[rajagopal]

Please find MOM.xls with my requirements

[zv735]

see att file

[rajagopal]

Two issues.

1. Data in J column in MOM.xls not updated in Action
item tracker.xls (It has to be updated in O column of Action item.xls)
2. Data in L column in MOM.xls is updated in O column of Action item.xls (It has to be updated in R column of Action item.xls)

Please help.

See the attache files for ref.

[zv735]

I adjust some column in Action item tracker.xls
for make different column of Mom.xls and Action item tracker.xls are five

see att file

[rajagopal]

Thanks.
is it possible to have two worksheet change events in the same sheet?
One for action item update from MOM.xls and another worksheet change event function for auto population of date.

Please guide.

[rajagopal]

'This code for auto population of action item tracker

Dim LastLine As Long
Private Sub Worksheet_Change(ByVal Target As Range)
If TypeName(Intersect(Target, [InputRange])) = "Range" Then
Workbooks.Open Filename:=ActiveWorkbook.Path & "\Action item tracker.xls"
Windows("Action item tracker.xls").Activate
Sheets("Action item tracker").Select
If (Target.Column = 4) Then
Application.Goto Reference:=Workbooks("Action item tracker.xls").Worksheets("Action item tracker").Range("I65536")
LastLine = ActiveCell.End(xlUp).Row + 1
End If
Application.Goto Reference:=Workbooks("Action item tracker.xls").Worksheets("Action item tracker").Cells(LastLine, Target.Column + 5)
ActiveCell.Value = Target.Value
Windows("Action item tracker.xls").Activate
ActiveWorkbook.Save
ActiveWindow.Close
End If
Application.ScreenUpdating = True
End Sub

'This code for auto save when cell d8 is changed.
If TypeName(Application.Intersect(Target, Range("d8"))) = "range" Then
Application.Dialogs(xlDialogSaveAs).Show
End If

How can these two be merged as a single change event?

Please help asap....

[rajagopal]

Also, column B (S.NO) has to be updated whenever the row is updated with the action items.
Give the code for the same.

Please help

[rajagopal]

sorry for my repeated updates.
Cell D9, D13, I13 values in MOM.xls should be auto populated in action item tracker.xls in cell range E7, C7,G7 resply.
This will be the same for all action items of same MOM.

Please help.

[zv735]

see att file

Thank you