ExcelBanter - copy column to another file

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy column to another file (https://www.excelbanter.com/excel-worksheet-functions/251544-copy-column-another-file.html)

climate

copy column to another file

Hi
I have many file with six worksheet titeled: typeone-bob to typesix-bob.
I need to a macro, when run it on any worksheet, copy column "I" of any
worksheet to another file (box.xls) and set to column "I" to .....
respectively.

any help will be greatly appreciated.
climate

All times are GMT +1. The time now is 01:33 PM.