Hi,
I am in need of help. I have been trying to manipulate different codes i found with no success yet. I need a code that will go through a folder and copy data from different workbooks into a single sheet of a separate workbook.
The destination workbook/sheet is Book1 Sheet1. The Source workbooks and sheets are all indivdually labeled with dates and times as well as serial numbers for the units. The first column in this sheet is my header columns for the data. The data i need to copy is in cells C6, C7,C10, C11, C12, C16, C21, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37, C38, C39, and C41. I need these items from each workbook to paste into the destination sheet in a single column, starting in column 'B' then go to the next column when pasting from the next workbook. Any help can be appreciated.
I am in need of help. I have been trying to manipulate different codes i found with no success yet. I need a code that will go through a folder and copy data from different workbooks into a single sheet of a separate workbook.
The destination workbook/sheet is Book1 Sheet1. The Source workbooks and sheets are all indivdually labeled with dates and times as well as serial numbers for the units. The first column in this sheet is my header columns for the data. The data i need to copy is in cells C6, C7,C10, C11, C12, C16, C21, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37, C38, C39, and C41. I need these items from each workbook to paste into the destination sheet in a single column, starting in column 'B' then go to the next column when pasting from the next workbook. Any help can be appreciated.