Jump to content

CELLS REFERENCED BETWEEN DATABASE IN A WORKSHEET


Recommended Posts

Hi guys, 

I am trying to reference cells from different worksheet to obtain the total of doors in a project. The only way that i know its just create a worksheet an copy all the information from the others worksheets. But i am a bit scared of lossing information when i am going to change something because the cells are not connected between them, they are copied.
 

I am going to attach some images.

The image 1 includes cells copied from the database of the others images.

Captura1-Puertas.JPG

Captura2-Puertas.JPG

Captura3-Puertas.JPG

Link to comment

You can reference cells in other worksheets by using the worksheet name as part of the function:

 

Working in a worksheet named 'Worksheet-A' and entering a cell formula of ='Worksheet-1':A4 will reference the value from a different worksheet named 'Worksheet-1'

 

The values in Worksheet-A will update when it is recalculated to the then current values in Worksheet-1.

 

HTH

Link to comment

I have tried to do that but when I work with Database, the reference doesnt indicate the subrow, just indicate the total of the sum value/item. I would like to indice 'Worksheet-1':A4.1 but it doesnt work.
I have resolved it creating two record formats, left and right openings and applying the record format manually to the doors and i dont need to reference the file.

Link to comment

Since database subrows are dynamic, there is no way to directly access the data from a subrow cell. In any way, in the local worksheet or a referenced one. 

 

By dynamic I mean that because cells can be sorted and SUMmarized in different ways, it is very difficult to guarantee that cell A4.1 will always have the value you want in it. If someone adds another object to the drawing the sorts above the current 4.1, it will be added and now what was 4.1 is now 4.2 or something else. And there is not good algorithm to be able to figure out what the user actually wanted.  Another example. You have data SUMmarized and cell 4.1 is the sum of 3 different objects. Someone turns off the SUM. How would your cell reference know that and what should it do as a result?

 

For some functions you may be able to use a spreadsheet version and specify the criteria you need to get the same value.

 

Or for some options you may need to go to a worksheet script that can get the correct data. Take a look at this thread for an example I recently did.

 

 

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...