Copying from Excel to OneNote is possible but you will lose important data through simple copying and pasting and a macro won't help. If you have both applications installed, just open your Excel file and select Print. From that list, choose Send to OneNote and the data from Excel will be sent to OneNote with all the items.