I'm not sure what you mean by performing some calculation on Sheet2. If you
are talking VB code (which is the main item discussed here in this
excel.programming newsgroup), why not perform the calculation in VB? And if
you are talking worksheet formulas, whatever calculation you are performing
on Sheet2 could be done in Sheet1 just as easily. Perhaps if you provide
more detail about your layout and what you are trying to do with it, maybe
things would be clearer.

--
Rick (MVP - Excel)


"Khoshravan" wrote in message
...
I want to put the calculation in a separate tab and results in other one.
Is it possible to use relative reference for addressing between two tabs?

To explain completely, I want to get A1 value from Sheet1 as an input
value,
take it to Sheet2, perform some calculations there and return the final
result of calculation as a single value to B1 in Sheet1 .