hi!
i’m currently trying to import some columns from a CSV file into one calc sheet that has it’s own columns and formatting,
so i have inserted and linked the CSV file into a second sheet to my Calc document, and thought i could reference columns from that csv sheet to my main one, however, i can’t figure out how …
i could easily reference individual cells one by one with commands such as =sheet2.A2 into my sheet1’s A2 cell and so on, but each column has 1400 cells so that’s simply not humanely possible … the result would be fine though
can I through a command or macro, have a whole column from my sheet2 copied automatically into a column of my sheet1 ?