Referencing cells between worksheets (if possible)

[Luciole Design]

Is it possible to reference cells between worksheets? I would like to take the total (sum) field from one worksheet and reference it in a summary worksheet. There is no data attached, no records - just a field in a worksheet.

My application: I have schedules with totals in one worksheet, and would like to include all the totals together in a summary worksheet. Right now, I have to enter the values by hand.

[Pat Stanford]

You can use a formula like

='Worksheet-2':B1

to pull data from one worksheet into another. The name of the worksheet you are getting the data from must be included in single quotes.

I don't think there is a way to get a single cell from a database range of a worksheet.

Pat

[gmm18]

So we can't use a formula that refernces a single cell from a database range at all? Or are you saying this is only if you are trying to do so when referencing from another worksheet?

[Pat Stanford]

As far as I know, you can't use a single cell from a database at all. I think the idea behind this is that since databases are dynamic, you can't know for sure what data will be in what row. If you add something to the drawing that changes the number of database rows, how would a formula adjust? Would it keep referencing the same row number, or would it have to remember the previous data and locate the new row? What about when you have referenced the cell and then delete the object that was associated with that row? All difficult questions.

If you can narrow the criteria of your database enough so that there is only a single object in the database you can reference the header row for the database and get the data from there.

Pat

[gmm18]

Makes sense,

Thanks for clearing that up for me.

[islandmon]

The KISS solution is to utilize a single "compiled" worksheet of indeterminate length which contains all the worksheet criteria for the entire project. Then use a Sheet>crop to selectively display categories.