I have a master list of launches in excel, each which includes a column for launch date. For all launches with a launch date in September, I would like the full row replicated into a separate tab labeled September (Sept tab has all the same column titles as the master list). I would like for this to happen automatically any time a new launch is added to the master list AND I want information that is updated on the master list to automatically update in the separate monthly tabs.
I am not a developer and am a rookie with excel so a simple "if/then" function I can do but complex code is a little harder for me to understand. Any recommendations?
Also, I am working with Excel 2007.
Parsing Rows of Data into separate tabs based on criteria