Thanks AlphaFrog. That works better, but it is not copying the entire row. Essentially, the goal is to look up info from inputbox (which is located in column "y") and copy and paste the entire row to sheets "template". It populates a list with checkboxes to select which row the user wants to use on sheets "Template". Note that the first few columns (up to column "Q" in "Contacts) do not have any relevant info in them (they may or may not be populated). They may, but it is not relevant. I need the info from column "R" through column "AA" to be pasted.
Thank you for your help.
Bookmarks