greatabby
New member
- Joined
- Aug 26, 2016
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Google Excel
Hi All,
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:
Sheet 1 created with the Name of Abdullah (because i want to name a field with ROW NAME)
Values for Sheet Abdullah
Sheet2 created with the Name ofBB (because i want to name a field with ROW NAME)
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.
NOTE: I want to do this in Google Sheet
Let me know if you have any questions
Thanks in Advance.
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.
NOTE: I want to do this in Google Sheet
Let me know if you have any questions
Thanks in Advance.