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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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