Copy part of a sheet

[Tshurlock]

I have a sheet with columns A-J which is regularly updated for internal use. Is it possible to have a macro that will copy/update only columns B-I to a different workbook for external sharing?

 

[oldbrewer]

switch on record macro, then copy columns A to J, open the new workbook, paste, close the new workbook, END the macro then view the code - it should then be easy to tweak it................