EXCEL automatic duplicate range

Hi,

Is the "automatic" copy needed after every single change to the source worksheet?

The worksheet (or even the workbook) could simply be copied in entirety.

It is a lot of work/time (& processing at run-time) to track every single change to a worksheet just to mirror this elsewhere, so your reason(s) for the necessity for the "automatic" copy would be helpful.

I have to wonder why you would want an exact copy of a worksheet.  Having a copy one step behind the current version would seem more practical (so you can reinstate that if an error has been made in the original).

Thanks for your clarification of your intentions.

Mirroring a single column, however, is faster but not quite as accurate (depending on what changes are made) as not all changes will be able to be tracked on a single column basis; font names/sizes, for instance.

BFN,

fp.

Hello fanpages.
Thank you for your answer.

The mirroring concerns values (numbers or text), calculated or not calculated. I don't want to track font names or sizes changes.
I want the destination sheet be automatically refreshed when the user is working on the source sheet, when he deletes or inserts a line on the source sheet. If possible, the user who fills the sheet has to do nothing in order to change the destination sheet.

So ...
Is that done by using a button with VBA code behind? (the user does something but ...  just clicks ... or is there a better event to be tracked?)
Or is there a solution without VBA code (I would prefer)?

Thanks

ml

Thank you again.

Not understanding your intentions may mean that potential pitfalls are missed.  It may be the case that the purpose of mirroring data can be achieved by other (easier, more robust, quicker) methods, for instance.

YES ... of course. I shall be careful when using your recommendations.
Sometimes, you just want to do some calculations using a column calculated elsewhere in a (source) sheet and SEE that column in another (destination) sheet  before doing other calculations on it.

As I am sure you are aware, mirroring data from one worksheet to another is usually performed by just referencing the source cell within the destination cell with an in-cell formula.  However, the inserting &/or deleting of rows from the source worksheet (or range) that will cause issues if the in-cell formulae results in #REF! errors.

YES, that is the problem. As you can reference the source cell within the destination cell, I wondered whether it could be possible to "reference a source column within a destination column" ... that is not possible, that's it?

A solution without VBA code (as a fully manual process) would be simply to copy the source worksheet to another worksheet (either within the same workbook, or in another workbook).

YES, that is what is done now. But I want a more automatic process.

I am presuming that the mirrored/destination worksheet is within the same workbook as the source worksheet/data.   Is that the case?

YES

A button can be provided as a semi-manual process,
So ... I  code a macro to copy the desired column or the desired range and launch it when the user clicks on a button

the event can be fully-automated when an insertion or a deletion of a row is detected.
OK but I need to take into account that the user just fills a cell.
Is there an event for that or Is the following solution good?

Solution:
- catch an insertion or deletion of lines
- but instead of copying the column Columns("X:X").Select     Selection.Copy
write a formula in each cell to reference the source cell within the destination cell with an in-cell formula (=!source.Xi for example). But
Is that done in VBA with a loop on cells or is it possible to define a formula for the column?

Thank you for all ...

ml


Thank you.