I am trying to copy columns A, B & C from sheet 1 into sheet 2, but I want it to change sheet 2 when I add to sheet 1. Is there anyway to do this? I am self taught on calc, so more simple explanations would be helpful. I am also attaching a sample of what I am working on. Thanks in advance!
Test 1.ods (19.8 KB)
I feel sure that you don’t need a copy, but can work with values pulled in by formulas.
This may require filling down these formulas once in a while.
See example (you may there paste-in your test contents into Sheet1).
disask_126705_PullContentsResultsFromOtherSheet.ods (18.7 KB)
If you urgently need pushed copies for unknown reasons you can only automate it with the help of user code.
See A2 on Sheet2. To extend it to other cells, simply grab the drag handle - the small square bottom right of the active cell - and drag down/across as required.
Test 1.ods (16.6 KB)
1 Like
This seems like the solution to me!! I can’t believe I didn’t figure it out, been working on it for an hour!! I appreciate your help so much!!!
You should mark the post by @robleyd as the solution then.
[There is one flaw: If you fill-in the formula down and/or rightwards you will get 0 (the number) for empty cells in the source.
To avoid this you need a slightly more complicated formula as demonstrated in my suggestion.]
Hmmm. Scaling will be more complicated as soon as an array formula is used.
In addition i think the complete range will be rewritten/recalculated if just one referenced cell is set dirty and accessed later. Tell me, please, if I’m on error.
1 Like