Copy formula!!!

[brooklyn2007]

Hello guys. I have this problem. In Sheet1 I have many formulas that use as references data from a specific range. When I copy this formula to the Sheet2 (same workbook), it does not use the reference in Sheet1, instead, it uses the same range in Sheet2. I need a way to copy these formulas in sheet2 and use as a reference datas of the specific range in sheet1. Is there any solution for this kind of problem? Thx

Below a simple example:

Excel Workbook
	A	B	C	D
1	23	*	35	*
2	12	*	*	*
3	*	*	*	*
4	*	*	*	*
5	*	*	*	*
6	*	*	*	*
7	*	*	*	*
8	*	*	*	*
Sheet1

 

[GlennUK]

Why are you wanting to do this ..... what is your overall aim?

 

[brooklyn2007]

Why are you wanting to do this ..... what is your overall aim?

It's ok, I found the way by just doing cut and paste the formula to the next sheet. i didn't think it was that easy. I was doing some new arrangements to data in the workbook that's why I needed to know the solution

 

[GlennUK]

Cutting is not the same as copying ... I'm glad you got what you wanted.