Excel 2007 : Need suggestions on linking a range of cells from one worksheet to another worksheet.

Hello,

I have a workbook where worksheets contain data imported from Quickbooks, each worksheet represents a report within Quickbooks. I have a so called summary worksheet that calls on data from each of the report worksheets.

I would like to have a range of cells displayed on the summary sheet that originates from one of the feeder sheets. Copy and paste is out because it defeats the purpose of the automation I have setup in other parts of the worksheet. Also, I don't know Visual Basic, so macros are not in the cards at this time. Ideally, I would like to utilize a function(s) to automate the process. Is there another tool within Excel that could be good option (e.g. linking reports, tables, groups, panes, etc.)?

Any suggestions?

Sincerely,

tykomusic

The standard worksheet function to copy a cell from one sheet to another sheet, within the same workbook is

='SourceSheetName'!A1

or

='SourceSheetName'!$A$1

So if there are two sheets(Sheet1 and Sheet2). On Sheet2 in cell A1 is some data(call in "DOG"). On Sheet1 you want this data from Sheet2 to appear at cell B10. In cell B10(on Sheet1) you type

='Sheet2'!A1

When this function is entered, you will see "DOG" appear in cell B10(on Sheet1).

Hope this helps.