I need VBA that creates a new sheet for every data entered in column D
Solved/Closed
dmatrix00
Posts
2
Registration date
Tuesday December 25, 2018
Status
Member
Last seen
December 26, 2018
-
Updated on Dec 25, 2018 at 01:40 PM
Blocked Profile - Dec 26, 2018 at 09:40 AM
Blocked Profile - Dec 26, 2018 at 09:40 AM
Hi,
I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data to sheet and if the name is repeted add that row data too, also the new sheet that is created has a format
ex.
d2= temp ---> new sheet: nama=temp / all data from a2:i2 move to new sheet (temp) / with the format that i created new na
d3= coin ---> new sheet: name=coin / all data from a3:i3 move to new sheet (coin) / with the format that i created
d4= temp ---> old sheet: nama=temp / all data from a4:i4 move to old sheet (temp) / with the format that i created
all sheet format are the same but they have some formula
I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data to sheet and if the name is repeted add that row data too, also the new sheet that is created has a format
ex.
d2= temp ---> new sheet: nama=temp / all data from a2:i2 move to new sheet (temp) / with the format that i created new na
d3= coin ---> new sheet: name=coin / all data from a3:i3 move to new sheet (coin) / with the format that i created
d4= temp ---> old sheet: nama=temp / all data from a4:i4 move to old sheet (temp) / with the format that i created
all sheet format are the same but they have some formula
Related:
- I need VBA that creates a new sheet for every data entered in column D
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Vba case like - Guide
- How to enter @ in laptop - Guide
- Display two columns in data validation list but return only one - Guide
Updated on Dec 26, 2018 at 01:40 AM
check them and sum up some of them
Dec 26, 2018 at 09:40 AM
Read a set line by line.
If a particular word is found in D, then move the row to a sheet named whatever was in D.
Continue to place the data rows onto its own sheet until it is done?
Is this correct?
This should do it:
You just have to use this paradigm, and apply it to your model.