I have just started a new job which use excel for everything.

Currently they receive a spreadsheet which has multiple columns and rows of data. Each row of data is then extracted using "copy & paste" to put into their templete.
What I was hoping is there a way to create a Macros that will extract a selected line of data and put that data into the correct boxes on the templete?

Thank you