Hi,
I am having trouble figuring out the correct code that will copy the Row title on Sheet 1 to Sheet 2 based on criteria in columns E & F on Sheet one.
The Criteria required needed to return the building name is no activity in 2014, column E, and activity in 2015 ,column F, any activity is acceptable both positive and negative. If the criteria is met I am trying to copy the building name to sheet two, if the criteria is not met then move on to the next row.
I have attached an example spreadsheet. Also, if there are formulas that would work better I am not opposed to using them.
Thanks in advance for the help.
Bookmarks