Ask Your Question

copy entire column automatically [closed]

asked 2014-09-10 21:32:27 +0100

mamamamamamamamario gravatar image

So I have Sheet 1 and Sheet 2.

Sheet 1 will have a certain number of columns and an unknown number of rows. I need to copy certain columns over to Sheet 2. So I go to sheet 2 and select A1 and type "=Sheet1.A1" and hit enter. Then I can drag that down to copy that formula into cells below.

My question is how can I automate that? I am dealing with dozens of columns and I don't know how far down they go. In Google sheets you can do =arrayformula(if('Sheet 1'!A1:A,'Sheet 1'!A1:A,"")) which copies whatever is in sheet 1 A1 to Sheet 2 A1 or leaves it blank if it is blank, and it continues to the end of your rows automagically. Does Calc have anything analogous to that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 17:55:17.516265


Since the question wasn't really answered. One way would be to manually enter a reference to Sheet1 cells in a row or two of Sheet2, ie, "=Sheet1.A1", "=Sheet1.B1", etc, etc.

Then select a large range of cells in Sheet2, then select Menu > Sheet > Fill Cells... > Down and it will continue the manual sequence automagically.


However, reading between the lines, the OP might have just wanted to copy the whole sheet. Ie, rightclick on the Sheet name, "Move or Copy Sheet..."

Paul451 gravatar imagePaul451 ( 2018-02-17 07:44:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-10 22:03:21 +0100

mamamamamamamamario gravatar image

updated 2014-09-10 22:04:05 +0100

I figured out how to somewhat automatically do it with macros. In the Range selection box type Sheet1.A1:A123455 and copy that, then go to sheet 2 A1 and paste. And repeat for every column... Can't figure out how to get it to create the new sheet automatically though.

Pretty sad that such a useful function isn't present

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-10 21:32:27 +0100

Seen: 1,172 times

Last updated: Sep 10 '14