The macro recorder is your friend. Show us your efforts for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"fedude" wrote in message
...
I have 2 sheets in a workbook. Sheet1 contains 25 rows of data. Sheet2
contains a column of 5 cells that are the basis for a large calculation
within that sheet. Today I'm manually loading up the 5 cells and then
running a macro to print out the results.

I want a routine that loops through the 25 rows of Sheet1 and for each
row,
copies 5 of the cells (in that row) into the appropriate cells in Sheet2
and
then run the print macro. I'd like to run this routine from Sheet2 if
that
matters.

The data in Sheet1 is in rows and the destination of the values in Sheet2
is
in a column