#1
|
|||
|
|||
How to share cell data between tabs of workbook?
Hi Gang,
Sorry a noob question here. I have created a workbook with several worksheets/tabs. Now I want to create a summary sheet so that I can get a grand total of the amounts from all the sheets. I swear I have done this before but I have pulled a major brain cramp and can not figure out what formula or what syntax I need to use to get the information into the current sheet. So again what I want to do is pull information from one specific cell on a sheet and place that data into a cell on the current sheet. All help will be greatly appreciated. Keith |
#2
|
|||
|
|||
Select the cell on the Summary sheet where you want the data to be displayed.
Type the = symbol and then use the mouse cursor to click the Sheet name where the data is located, then select the exact cell and press Enter. The address in the formula bar should look similar to =SheetName!C5. Let me know if you need further assistance. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reference another workbook and return values from the same cell across multiple sheets/tabs | lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
Share my data on via MYSQL??? | cwksr | Excel | 0 | 08-24-2014 03:23 AM |
Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Share Workbook cannot merge | Ichigo | Excel | 3 | 01-19-2010 03:05 AM |