i have a listbox that has about 15 columns and I want to be able to click a row in the listbox and have that 1 row(15 columns) paste into a range on a worksheet. Each row is a name, address, phone #.....

each row is a unique customer....

The list is connected to a range on a separate sheet.

Thanks...