Moving cell data between sheets in a workbook

Little Mike · #1 05-04-2016, 03:07 AM

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 · #2 05-04-2016, 05:30 AM

=[sheet 2]!AA138

Little Mike · #3 05-04-2016, 04:05 PM

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 · #4 05-04-2016, 11:40 PM

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 · #5 05-05-2016, 02:45 AM

Thank you very much. It works brilliantly.

gebobs · #6 05-05-2016, 06:22 AM

Ooops...yeah, brackets are wrong.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need vba code export data to closed workbook sheets	manilara	Excel Programming	1	02-12-2016 08:20 PM
Summarizing data in a workbook which the sheets contain verndor names in different orders.	pad	Excel	3	10-14-2015 07:33 PM
How to share cell data between tabs of workbook?	littlekeith	Excel	1	03-23-2015 06:21 AM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM