Dear all,
What I am trying to do, is that:
1. Once a new row is filled in sheet A
2. A new sheet is created
3. That new sheet is named as per Last name and first name columns from sheet A (Columns K and L)
4. And in that new sheet, the rows are filled based on the columns of sheet A.
Example for point 4. : in sheet A, the last name and first name are Doe John. In the new sheet created, cell B2 should be = John and C2 = Doe. The sheet name should be JohnDoe.
And finally, that new created sheet is hidden.
I looked through multiple forums but cannot seem to find anything relevant, not even close to what I am trying to do.
Here I am relying on your exceptional Excel VBA skills to help me
Thanks a lot to you all.
What I am trying to do, is that:
1. Once a new row is filled in sheet A
2. A new sheet is created
3. That new sheet is named as per Last name and first name columns from sheet A (Columns K and L)
4. And in that new sheet, the rows are filled based on the columns of sheet A.
Example for point 4. : in sheet A, the last name and first name are Doe John. In the new sheet created, cell B2 should be = John and C2 = Doe. The sheet name should be JohnDoe.
And finally, that new created sheet is hidden.
I looked through multiple forums but cannot seem to find anything relevant, not even close to what I am trying to do.
Here I am relying on your exceptional Excel VBA skills to help me
Thanks a lot to you all.