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

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.