Update corresponding cells on master sheet when data entered to filtered sheet

Hi I am new to VBA and have a limited understanding of it’s workings.
I want filter results from a master sheet onto separate sheets (achieved).
The results on the filtered sheets have data that needs to be added to the row. So if I updated the filtered sheet , row C cell 2, then the master sheets corresponding row in column E will update the same line of information.
Does that makes sense?
The filtered data changes often, each time the macro is run (due to other parts of the master sheet being changed). The data I entered on the filtered results needs to be saved on the master sheet and when the filtered results change column C on the filtered sheet need to correspond with the master. So blank if it’s column E cell is blank or show whatever data is already there (not too important that part)
Any help would be much appreciated. I have tried a number of things though I think I would confuse things if I quoted what I have tried as I am not a very competent user. Thanks.

The solution would be a worksheet_change macro that applies to your other sheets. The macro would watch columns B:C on the filtered sheets and anytime a manual change is detected, the macro searches the original Master Sheet for the same name and puts the correction in.

There is even a worksheet_change macro that you could put into the ThisWorkbook module that would then apply to all sheets.

To do this correctly, your sample workbook needs to be EXACTLY what you're trying to do. I assume there are more filtered sheets, or no?

Can you expand you sample to demonstrate your full workbook? Are the some sheets this would apply to and others NOT? Obviously this would not apply to the Master Sheet, but are there others to ignore, too? Or is there a common naming scheme for all the sheets to pay attention to?

As described above, put this macro into the ThisWorkbook module and it will watch every sheet except Master Sheet and attempt to transfer your manual changes back to that sheet.

Please Login or Register  to view this content.

This is how I would do that, this allows you to design a column-to-column map in the SELECT() section of the code. When a change is made to a cell in column E (column 5) on a group's sheet, that is translated back to column N on the Master Sheet.

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

It turns on "code checking". Basically makes errors stand out.