Replicate field in different tabs.

[Anonymous]

Hello.

On a tab I have an "object graphic" in various fields.
I need to create another tab with another "graphic object" where I have to bring the results of a field that first tab.
The question is how I have to point the field in another tab?

[kji]

All tabs share the same database so it should work automatically.

[Anonymous]

It's the same bank.

The problem is that I need to bring in guia2 and the result of a field that is in an object table in guia1.

I do excel in the following way:

Sheet (Sheet1). Range (a1)

[Anonymous]

Hi Washington,

What Johan means is that when you use the same formula in one sheet it will give the same result in an other sheet. So if you want the result from one field (sheet1) just use the same formula in the other sheet.

That should work imo, or am I missing your point?
If so maybe you can add an example to the post.

Kind regards,
Dennis.

[Anonymous]

In each object I have 10 columns. These columns are making calculations between them.
EX: A + B = C C + D = E (E * A) / D = FA * F / C = G .....

The formulas that are in these columns are very complex, are financial calculations.

Are the formulas I use I'll have to break all the columns bringing these formulas for the column eg H

It would be much easier if the other guide I could say that guia2 field [field name] = guia1 the field [ H ] .

[#6]

You could define the expression you use in a variable then use the variable value wherever you need it. This makes it more maintainable, but no you cannot reference to the calculated value in an expression you have used somewhere else.

Regards,

Gordon

[greg-anderson]

If you are going to use the same calculation in multiple areas of your QV workbook, I would recommend putting the calculation into your load script.

Then, as Gordon suggested, assign that calculation to a variable that can be easily reused throughout your document.

This also gives the added benefit of single-point modification if anything about that calculation changes in the future.

-Greg

[Clever_Anjos]

Washington,

Converta as expressões em variáveis e reaproveite entre as duas abas