0

From an original cell, I enter a value then the formula need to populate other cells , , ... The data are in the same worksheet that the displaying one. They are organized by row (each row represents a client)

1

You should be able to switch to another sheet and simply select the value you need by clicking on it. You should end up with a formula like this (that calculated the mean of a value from different the current sheet and another sheet called Sheet1.

=(J2+'Sheet1'!J32)/2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.