Moving cell data between sheets in a workbook

[Little Mike]

I'm trying to move data from sheet 2, cell #AA138 to sheet 7, cell #B4. These are in the same workbook. Is there a formula that I can enter to move this data as it's being generated from one sheet to the other without cutting and pasting?

[gebobs]

=[sheet 2]!AA138

[Little Mike]

The data is as follows; Male 129, this is cell AA150 on Sheet 2. I'm trying to move it to Sheet 7, which is expressed as; Male 0, cell B4. I tried +[Sheet2]!AA150 in the cell on sheet 7. Yes the cursor was on the correct cell (B4) on sheet 7.

It tells me that there is an error.

I do appreciate your assistance.

[xor]

I would use ='Sheet 2'!AA138 if sheet name actually has a space between t and 2.

If sheet name is Sheet2 you can just use =Sheet2!AA138.

[Little Mike]

Thank you very much. It works brilliantly.

[gebobs]

Ooops...yeah, brackets are wrong.