Miguelluis
New Member
- Joined
- Jan 29, 2013
- Messages
- 45
Hi,
I've got a workbook with over 150 sheets all in different layouts. I need to extract two columns from all of the different sheets into one, the two columns are titled 'ID Client' and 'ID Holder' and unfortunately some rows are blank and the columns are not in the same position for all the sheets and contain numbers and text.
Is there a way to extract all this data into one sheet and have it copied down, similar to the append option. They can be extracted to a new sheet in the same workbook.
Many thanks
Miguel
I've got a workbook with over 150 sheets all in different layouts. I need to extract two columns from all of the different sheets into one, the two columns are titled 'ID Client' and 'ID Holder' and unfortunately some rows are blank and the columns are not in the same position for all the sheets and contain numbers and text.
Is there a way to extract all this data into one sheet and have it copied down, similar to the append option. They can be extracted to a new sheet in the same workbook.
Many thanks
Miguel
Last edited:
