Copy Selected Range From One Sheet To Multiple Workbooks Sheets Using VBA

[olives]

Nice! Ok, quick question, with this I can copy range J:J and it will paste straight into Column J of all the spreadsheets, right? Since I only see J:J in the code once, I suppose that as it's written this will copy to the same place where it was copied from - but in the close workbook...