View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Function Question

Having Issues wrote:
I am actually trying to copy cells from the top of the page to the bottom of
the page. Like a half page invoice. Copy the top invoice to the bottom so the
exact invoice appears on both halves so I don't have to print 2 pages of the
same invoice.
The top contains data and functions.



Assume the "top" page starts in cell A1 and continues down and across to G20.
In cell A21 enter the formula =A1 and then copy down and across to cell G40.
Select rows 1:20 and copy them. Then select rows 21:40 and Edit / Paste Special
/ Formats.