Copy page info multiple times in same page

**concretetsunami** · 09-29-2008, 09:49 AM

Attached is the project that I am working on.

Here is what I would like to do it is probably something simple, but I don't fully understand functions and formatting in Excel. I need to copy all the information within the page "Cal Sheet" and then paste it on the same worksheet but under it. I need it to pull all the same information for each pasted copy (i.e. formulas)

The second thing that I need to do after I paste all of the copies needed (31 copies on a single page). I need the date to increase by one day on each new page. I know this might be a little confusing, so let me know if you don't understand the question. Thanks in advance.

**concretetsunami** · 09-29-2008, 10:22 AM

I figured out the date issue, I just need help to figure out the copying issue.

**concretetsunami** · 09-29-2008, 10:29 AM

Nevermind I think I figured it out. If I change all my cell references to have "$", it copies over.

**Cheeky Charlie** · 09-29-2008, 10:34 AM

You can press F4 to cycle through the different variants of absolute and relative cell referencing.

You can also copy '1' (without quotes) and edit->paste special -> add onto an area to add 1 to every number in the area.

Very effective that paste special.

HTH

**concretetsunami** · 09-29-2008, 11:22 AM

Originally Posted by Cheeky Charlie

You can also copy '1' (without quotes) and edit->paste special -> add onto an area to add 1 to every number in the area.

Very effective that paste special.

HTH

I don't understand what you mean. Are you talking about the date issue?