Hi! I'm new to VBA and am looking for a code that allows me to automatically insert rows based on a cell value. For example, I downloaded a huge csv. file of 21 years worth of data. The first column is year (2000-2020) and the second column is state followed by more columns of data. Sometimes the state doesn't have data for all 20 years so I'd like to automatically insert the years it doesn't have data so I get a consistent format for copy/pasting into another spreadsheet. My goal is to have a row for each year (2000-2020) for each state that I've downloaded data for regardless if I have data or not. Thank you for any assistance!