I have 2 Excel files. One is a standard form which I fill in certain cells with information from another spreadsheet and then print it off. I would like to create a Macro to choose the row which will pick information from specific cells (which would always be the same column) and automatically print this off.

I know this is possible as I use another sheet with such a macro, but cannot work it out from this (especially as I'm very much a novice).

Any help would be greatly appreciated.