Formula for same value in cell on different sheet

Hello

I have a cell in Sheet Hurtic Calc N5 , can it be done so i have the same value in Sheet Tilbud EXC2 AS34, and if i change the value in one of them the other change to

No ... because cannot have both a formula and value in a cell; and you will get a circular reference. Can be done with VBA

Hello

Ok.. can i have a match so in Hurtig Calc N5 is the same as in Tilbud AS34

or how will a vba look like for my first question

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello

i must think a little bit more how we want it, i will come back, thank you so far

OK. Ii is often difficult to respond to questions succinctly if we cannot see the context of the requirement.

Hello

I have sheet Tilbud EXC2 cell AT46, AT47, AT 48 that should be the same as in Prod EXC2 Q58, Q59, Q60

And in Tilbud EXC2 AT52, AT53, AT 54 that should be the same as in Prod EXC2 AA58, AA59, AA60

And in Tilbud EXC2 AT58, AT59, AT60 that should be the same as in Prod EXC2 AD58, AD59, AD60

those are controlled in more sheet by this formula in P19,

Formula:

Please Login or Register  to view this content.

, and this formula in Q19

Formula:

Please Login or Register  to view this content.

and this formula in N19,

Formula:

Please Login or Register  to view this content.

So what i want is to controll this formula, eighter i stand in one sheet or another, and the vale will always be the same in both sheets



Hope you understand

All the values you refer to in AT46, AT 47 and AT 48 etc are constants (not derived from any formula) BUt are they themselves are used in P19 and Q19 but not N19.

So I am not sure what you require: at the simplest you could refer the values in Prod EXC2 by formula i.e in Q58 put "='Tilbud'!.AT46" so the 2 sheets are aligned BUT this assumes that sheet Tilbud is the master so only change values in this sheet.

Hello

I know i can do it like that, but i was thinking the constant value can change in both sheets , no master sheet

i will controll the different value from different sheets but it will be the same constant value on both

AT 46 are controlled N19 / Wish that Tilbud EXC2 AT46 AND Sheet Prod EXC2 Q58 are controlled N19
AT 47 are controlled P19 / Wish that Tilbud EXC2 AT47 AND Sheet Prod EXC2 Q59 are controlled P19
AT 48 are controlled Q19 / Wish that Tilbud EXC2 AT48 AND Sheet Prod EXC2 Q60 are controlled Q19

i will be several rows more yhis was just an example on row 19, 20, 21

But maybe what i want can not be done, even with vba

AT46 are NOT controlled by N19 etc - they are constants (values) which can only be manually input (no formula present): they are USED by N19 etc.

If you want the option of changing the values in either sheet then you need VBA.

Hello

I found this add add my data for test, and it works, so i will try to play with this for add data, Thanks for all help

Sheet 1

Please Login or Register  to view this content.

Sheet 2

Please Login or Register  to view this content.

These should work OK.

Hello

i am not sure how to add the lines for AT69, and AT70