Ok, I have a massive spread sheet built with multiple collapsible groups. I have vlookup formulas to auto populate the majority of the data from the ID number entered on the main line for each group. Now my question is, is there a way to paste a list of ID numbers from another sheet where it only puts the ID in the visible cells.