I have a few different lists all in one worksheet. For example my first list has a label in a1 with a name in it (lets call it list 1) then in row a2-I2 are the headings then in rows 3-wherever (depends on how many rows are needed which will change all the time) is all the information. Then lets say that in a20 is the start of list 2. so a20 will have the name (lets call it list 2) and a21-I21 are the headings and rows 22-wherever is all the information and this continues through 10 different lists.
Right now I have it setup so when I put the word yes in column I it deletes that row and copies it to the next available row on worksheet 2.
What I'm wondering is is there a way that when it moves the row from worksheet 1 to worksheet 2 it will put it in the same list format. So if a row in list 2 has the word yes put into column I it will move it to worksheet 2 list 2 in the next available row and to do this for every different list.
Thanks