Hello. I am a new memeber with moderate excel experience. My problem is I am trying to create a macro to pull specific information if a condition is met. For example I would like to copy and paste A57:H57 from one work book to another, but only if K57 has a value. Or more specifically, I would like to seach a named cell range for values and copy and paste the text in the rows beside it. I don't even know if this is something I can do in excel or not. Please Help

Thank you,

Angelina