- I will enter into the cells Text Values from drop down boxes
- It then recognises if the text entered is equal to "Assessment" in the "B" column/"Level" Column in "Table1" . (If it is another text value then it leaves it. EG. Class)
- It then moves the whole row (Not the worksheet row eg, "E" Just the table row) that the "Assessment" value is found in to "Table2" while retaining the data that is existing there. I also need it to retain the existing formatting so once the row has been copied over I am still able to use the dropdown box to enter another row.
- It then runs the existing macro that sorts the dates from oldest to newest
Does that help?