Excel -- Copying Formulas

AmyDawn · 11-02-2009, 04:33 AM

Hello,

-- First, I will explain a litte of what I did and what I need to do.

I have created a spreadsheet in Excel. I then have created a second sheet within the same workbook. The second sheet has 1 page currently and there are a number of formulas that reference cells on Sheet 1.

To be simple. On Sheet 2 I have a cell that references A1 on Sheet 1.

What I am trying to do is copy this whole page in sheet 2 and continue to make 60 pages of this same sheet within Sheet 2. However, page 2 of Sheet 2 will need to reference A2 on sheet 1, and page 3 will need to reference A3 on Sheet1.

I need the pages to be identical in size - including keeping column and row width and formatting. I can just copy and paste regularly by selected the rows and then copy to the next available cell, but it does not copy my forumlas correctely.

Instead it is chaging the reference from A2 to A42. Is there a way that I can copy and paste this page and make the cells to go in consecutive order?

Thanks in advance!

11-02-2009, 04:33 AM	#1 (permalink)
AmyDawn Registered User Join Date: Nov 2009 Posts: 1 OS: Win98	Excel -- Copying Formulas Hello, -- First, I will explain a litte of what I did and what I need to do. I have created a spreadsheet in Excel. I then have created a second sheet within the same workbook. The second sheet has 1 page currently and there are a number of formulas that reference cells on Sheet 1. To be simple. On Sheet 2 I have a cell that references A1 on Sheet 1. What I am trying to do is copy this whole page in sheet 2 and continue to make 60 pages of this same sheet within Sheet 2. However, page 2 of Sheet 2 will need to reference A2 on sheet 1, and page 3 will need to reference A3 on Sheet1. I need the pages to be identical in size - including keeping column and row width and formatting. I can just copy and paste regularly by selected the rows and then copy to the next available cell, but it does not copy my forumlas correctely. Instead it is chaging the reference from A2 to A42. Is there a way that I can copy and paste this page and make the cells to go in consecutive order? Thanks in advance!