Update the main Tab

Hello all,

I have all the users in main tab and they have their own tabs, when they update their values in columns that should reflect in the main tab . How do I do this, any help is appreciated, I am kinda new to vba so need help..

Thanks a lot..
Main Tab - Debbi Total SubTotal Rev
Stace
Gracy

Debbi Tab Total SubTotal Rev


If debbi changes her Total, subTotal and Rev then it should reflect in main tab under her name...

Hello gaby58,

You really haven't provided any specific information about your layout or the code that is being used. Please post your workbook for review. This will speed up the process and get you a solution to your problem faster.

Sincerely,
Leith Ross

Please sethe attached spread sheet -

If anything is updated in Update-Monthly tab, it should reflect in Chart tab, for all test1 - test17 rows.

Thanks

Hello gaby58,

The following macro has been added to the attached workbook. Your starting row on "Chart" is 1 ahead of the other "Update" sheet. If you reformat the "Chart" sheet to match the format of the other sheet, remove the code in red in the macro.

Private Sub Worksheet_Change(ByVal Target As Range)

  Dim LastRow As Long
  Dim SrcRng As Range
  
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    Set SrcRng = Range("B5", Cells(LastRow, "E"))
    
      If Not Intersect(Target, SrcRng) Is Nothing Then
        Worksheets("Chart").Cells(Target.Row + 1, Target.Column) = Target
      End If
        
End Sub

Sincerely,
Leith Ross

Thanks, but it doesn't work quite, sometimes it updates and sometimes it doesn't. once it updated but it updated the down rows as well... any idea why it is this way.

Hello gaby58,

Is this workbook linked to other workbooks or being shared?

Sincerely,
Leith Ross