I am wanting to run a macro that will copy rows based on the cell value.

I have a sheet "Asset Data Dump" (Sheet1) where the criteria will match. The specific cells to looks for are in column A.

The criteria is in another sheet "Location Macro Results" (Sheet2) and the criteria are in column D, specifically D2:D4. These criteria will change periodically.
Site Building Room Location
106-Emerson_School East Building 226A 106-Emerson_School East Building 226A
106-Emerson_School South West Building 307 106-Emerson_School South West Building 307
106-Emerson_School East Building 219 106-Emerson_School East Building 219

FYI, column D (Location) is a concatenation of the other three columns, thus not a value but more of a result of a formula. Unsure if that matters.

I have a base copy/paste macro that has worked if I specify the value but not something that is dynamic that will change based on a cell value.

Please Login or Register  to view this content.
I am highly unfamiliar with VBA but am willing to learn. I thought it would be intuitive where I could set the criteria match to ask if column A of sheet 1 equals criteria 1 OR criteria 2 OR criteria 3 then copy to specified destination. I am unsure if it has to do with the concatenation, declaring the values as strings or if there is some term in VBA that encompasses multiples OR criteria.

I am flexible with the code. However I would prefer to not use filter in sheet 1 to give me results as commonly pasted filtered results generate surplus returns in my experience.

I am using Excel 2010. Thank you in advance.