Data Segregation Using Particular Column & auto update

Hi Mates,

Greetings!!!

Coming to the forum after a long gap with a new query... I've a excel file with multiple data's & looking for a solution that shall create a new sheet by filtering data's from master sheet using a value in particular column. Also when a change is made in any cells of the Master sheet, the changes gets updated in the corresponding sheet accordingly.

In the attached file, i have a Master sheet that has multiple data's, from that i have created the sub sheets by manually filtering contents using data in "Column G", so every time i update any value in the master sheet, the changes shall be automatically updated in sub-sheets.

In sheet code for sheet "Master sheet" put

Please Login or Register  to view this content.

"shall create new sheets " ... Ah! it was not prepared like that ... sheet must exist.
Update to come

In sheet code for sheet "Master sheet" put

Please Login or Register  to view this content.

In a module put

Please Login or Register  to view this content.

Hi Patrick,

Thanks for the code. Got almost to the one what i'm looking for.

So from the code i understand that, when the values changed in "column G", the changes gets updated in the corresponding sheet & any new value it creates a new sheet.

If we add n number of columns and rows, and need to take reference from nth column, where we should modify in the code, also i would like to have if any changes made in the Master sheet it shall reflect in the respective sub sheets accordingly with out manually updating it.

Can i use the same code in for the attached file to create sheets based on Z column and any changes made in any cell shall reflect in the respective sheets.

Thanks again, for spending your valuable time.

Cheers,

Rajesh

"If we add n number of columns and rows, and need to take reference from nth column, where we should modify in the code,"*
See next code and adjust

Please Login or Register  to view this content.

"if any changes made in the Master sheet it shall reflect in the respective sub sheets "
It means, when there is a change in "Master Sheet" you want to search the old record in the corresponding sheet (when exists) and update the information ...?

"Can i use the same code in for the attached file to create sheets based on Z column and any changes made in any cell shall reflect in the respective sheets"
Yes certainly

Please confirm previous questions and then we can update the code