I have information from one excel file ( lets say 15 columns of information) but I only need the data from 6 columns to be automatically added to another spreadsheet ( excel file)

What I would like to do is rune a macro from the original spreadsheet by manual selecting the run where the data is and have it open another spreadsheet and put the correct data in the other (new) spread sheet

Can some give me some Idea how I would even start this?

Howdy. Do you mean a new workbook or a new worksheet within the same workbook?

a new workbook