Best way of "mirror" several cell areas on one sheet to others?

[Imbecill]

I have several areas with information I want in the exact same cells in
other sheets [in the same workbook]. I first ran a macrorecording, but of
cource there is problems with that -
- It take a lot of time and power
- Difficult to do with worksheet_change or worksheet_deactivate without loop
because you need selections in the different sheets and that make events.

I have tried Function ='Sheet1'!B34 in cell Sheet2 B34 because it run on a
more effective code and not on a vb overlap. In that case you need a
=IF('Sheet1'!B34="";"";='Sheet1'!B34) to handel all empty cells.

BUT it will be a lot of links and if you move 'Sheet1'!B34 it will cause a
#Reference value in Sheet2 B34.


Folks, what should I do ???? I trust in you...

 

[Frank Kabel]

Hi
normally your function looks o.k. (just remove the equation sign in the
middle). So
=IF('Sheet1'!B34="";"";'Sheet1'!B34)
should work. Not sure what you mean with move cell B34.

 

[Imbecill]

Right, the equation sign is just a type miss.
The question is how to get cells in other sheets to take the same value as
on the "source sheet"

/Regards

Hi
normally your function looks o.k. (just remove the equation sign in the
middle). So
=IF('Sheet1'!B34="";"";'Sheet1'!B34)
should work. Not sure what you mean with move cell B34.

--
Regards
Frank Kabel
Frankfurt, Germany

I have several areas with information I want in the exact same cells
in other sheets [in the same workbook]. I first ran a macrorecording,
but of cource there is problems with that -
- It take a lot of time and power
- Difficult to do with worksheet_change or worksheet_deactivate
without loop because you need selections in the different sheets and
that make events.

I have tried Function ='Sheet1'!B34 in cell Sheet2 B34 because it run
on a more effective code and not on a vb overlap. In that case you
need a =IF('Sheet1'!B34="";"";='Sheet1'!B34) to handel all empty
cells.

BUT it will be a lot of links and if you move 'Sheet1'!B34 it will
cause a #Reference value in Sheet2 B34.


Folks, what should I do ???? I trust in you...

 

[Frank Kabel]

Hi
this kind of formula should work. But maybe i'm just not getting your
problem. What does not work for you with this formula?

--
Regards
Frank Kabel
Frankfurt, Germany

Right, the equation sign is just a type miss.
The question is how to get cells in other sheets to take the same
value as on the "source sheet"

/Regards

Hi
normally your function looks o.k. (just remove the equation sign in
the middle). So
=IF('Sheet1'!B34="";"";'Sheet1'!B34)
should work. Not sure what you mean with move cell B34.

--
Regards
Frank Kabel
Frankfurt, Germany

I have several areas with information I want in the exact same cells
in other sheets [in the same workbook]. I first ran a
macrorecording, but of cource there is problems with that -
- It take a lot of time and power
- Difficult to do with worksheet_change or worksheet_deactivate
without loop because you need selections in the different sheets and
that make events.

I have tried Function ='Sheet1'!B34 in cell Sheet2 B34 because it
run on a more effective code and not on a vb overlap. In that case
you need a =IF('Sheet1'!B34="";"";='Sheet1'!B34) to handel all empty
cells.

BUT it will be a lot of links and if you move 'Sheet1'!B34 it will
cause a #Reference value in Sheet2 B34.


Folks, what should I do ???? I trust in you...

 

[Imbecill]

Kind of you to ask!

Well, I have now disabled draganddrop, so it work ok. I have not tried to
find all kinds of activites a user do, but it seem to work without
draganddrop. If you draganddrop away a cell, it causes a reference value.

I want to keep the formats of the cells and had been forced to use
conditional formatting of the sheet. To solve the case with the possibility
that you paste merged cells in one sheet (wipe away cond. foramts...) I have
a sheet template with right conditional formats i "paste format" from when
worksheet_change take place.

I'll back when I've let my wife acceptanstested the file...that will cover
all kinds of ways a user could ruin good intentions

/regards

Hi
this kind of formula should work. But maybe i'm just not getting your
problem. What does not work for you with this formula?

--
Regards
Frank Kabel
Frankfurt, Germany

Right, the equation sign is just a type miss.
The question is how to get cells in other sheets to take the same
value as on the "source sheet"

/Regards

Hi
normally your function looks o.k. (just remove the equation sign in
the middle). So
=IF('Sheet1'!B34="";"";'Sheet1'!B34)
should work. Not sure what you mean with move cell B34.

--
Regards
Frank Kabel
Frankfurt, Germany


Imbecill wrote:
I have several areas with information I want in the exact same cells
in other sheets [in the same workbook]. I first ran a
macrorecording, but of cource there is problems with that -
- It take a lot of time and power
- Difficult to do with worksheet_change or worksheet_deactivate
without loop because you need selections in the different sheets and
that make events.

I have tried Function ='Sheet1'!B34 in cell Sheet2 B34 because it
run on a more effective code and not on a vb overlap. In that case
you need a =IF('Sheet1'!B34="";"";='Sheet1'!B34) to handel all empty
cells.

BUT it will be a lot of links and if you move 'Sheet1'!B34 it will
cause a #Reference value in Sheet2 B34.


Folks, what should I do ???? I trust in you...