I need to be able to take cell values from workbook 1 and paste them into the
next available blank row in column B of workbook 2. Is this possible and how
do i do it?

Thanks