need to extract two coulms from a workbook with 31 tabs

[abb16ott]

Hi,

I wonder if somebody could help me, I need to extract two coulms (AQ,AR) from a workbook with 31 tabs, I want colated the same colums from each one and copy into a new workbook. I have been searching for hours but have failed.

Can anybody help please on this the last day of 2008?


Thanks

Charlie

[Andy Pope]

Try this, it will process all worksheets in the workbook.

Please Login or Register  to view this content.

[abb16ott]

Hey, Thanks Andy,

I am gona give it a whirl.

All the best

Charlie

[abb16ott]

Thanks,

Yous are a SUPERSTAR!!!!! - worked great.

[Leith Ross]

Hello abb160tt,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save