I am trying to create a couple worksheets that once i add a line into one of the smaller worksheets the larger one is updated.
Example:

[General Sch] [Amy's Sch] [Bob's Sch]
Main smaller smaller

When i update Amy's Schedule I was hoping to find a way to automatically update the General Schedule worksheet. If you have any ideas or need more information i would be happy to provide whatever you need.

Also I’m quite new the excel vba coding environment. Is there any good website i could use to learn the lingo?

Well thank you for your time.
Brian

Dear Brian

You can use the Workbook and Worksheet events like

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    ' Copy the Contents from the Cell to the Main workook
End Sub

or

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

and copy the cells:

Regards
Shasur



http://www.vbadud.blogspot.com

maybe this is showing that i trully am a beginner with this stuff, but would the code then be to copy to the values
sheet1.cell(1, 2).value = object.target.value

or should i use the copy method

object.target.copy(sheet1.cell(1,2))

You can use the second method

Something like this should workout

Sheet1.cell(1, 2).copy Destination:=Sheet2.Range("A2")

Make sure that include destination



http://www.vbadud.blogspot.com