DUPLICATE THREAD CLOSED _ONE THREAD ONLY IS ALLOWED PER ISSUE HERE

Continue in the first thread here: https://www.excelguru.ca/forums/show...et-on-Each-Row


Hi All,

I don`t know if this one is possible with Formula, Please let me know.

Can anyone please help me out in this scenario? I am trying to add a sheet on each and every row, and as soon as any column update in that row, it should update the sheet as well.

Below what i am trying to achieve:

1. Whenever a new row added and the column CreateSheet has a value "True", it should create new sheet with the same "Header" (First ROW) of the sheet to each and every sheet and it should copy the row all columns to the new sheet with all the values
example:

Main Sheet:
FirstName LastName PhoneNumber DOB State CreateSheet
Abdullah Sikandar 111-111-1111 09/09/09 TX True
AA BB 111-222-222 09/08/1980 TX True

Sheet 1 created with the Name of Abdullah (because i want to name a field with ROW NAME)
Values for Sheet Abdullah
FirstName LastName PhoneNumber DOB State ID
Abdullah Sikandar 111-111-1111 09/09/09 TX 189371

Sheet2 created with the Name ofBB (because i want to name a field with ROW NAME)
FirstName LastName PhoneNumber DOB State ID
AA BB 111-222-222 09/08/1980 TX 548410


2. As soon as any field updated in any one of the column on Main Sheet, it should update the column in the created Sheet.
Example:

If Phone number got updated in Main Sheet for Abdullah ROW then it should be updated in the sheet "Abdullah", Same thing if any column got updated in sheet "Abdullah", it should update the "Main Sheet" column as well.


Let me know if you have any questions

Thanks in Advance.