Selecting Value In Bulk
There is an Excel file that teaches how to perform the Selecting Value In Bulk operation.
Excel Powered Selecting Value in Bulk
This workbook demonstrates selecting value in bulk using VBA macros on a 1-row data layout.
Hope it is useful.