I'm not sure if this is possible but if it is, it would make my life a lot easier. I have a spreadsheet full of data with columns financial information from a prior year and then current year. They all have a store number in common. I was wondering if there is a way to have excel look at column A and compare it to column N and if the information matches move to the next row but if the information does not match then I need it to add blank rows in columns N thru S. Is this possible and does what I'm asking make sense? Thanks so much!!