Hello,
I am trying to have Excel auto-populate a row based on data entered in another row if a specific cell is selected. See snapshot and example worksheet. Referring to my example, row 2 has data entered with 'Dog' as the category. Because the input is 'Dog', that row gets copied down into row 11. Row 3 has 'Cat' as its category, and therefore, that row gets copied down into row 14. Row 4 has 'Bird' as its category, so that row gets copied down into row 18. So and so forth as I continue to enter data in rows 5, 6, & 7, it gets filtered and copied down below.
Excel Q.png
Bookmarks