Forum Discussion
Code to copy data from one column to another in same workbook but different sheet?
Hi Lalla,
Actually Google Sheets doesn't copy one column to another whith this formula, what it do that's link target column to source column.
In Excel there is no such formula which do the same, however you may link two columns (or ranges) manually, see for example here https://www.techwalla.com/articles/how-to-link-columns.
That's not exactly the same, but simular. In Google Sheets if you type something in target columns that's break you link at all. In Excel links will be on cell by cell basis - if you put something in target column you break link only for changed cell.
In general quite many is compatibel between Sheets and Excel, but not all. Here is some guidline https://support.office.com/en-us/article/Switch-to-Excel-from-Sheets-54b2c938-1334-41c7-a43f-522a1f029294?ui=en-US&rs=en-US&ad=US#ID0EAABAAA=Differences, but quite high level.
='Sheet1'!B2
on Sheet2 A1 to copy data from sheet1 to sheet2.
Feel like something so trivial should be posted considering I'm looking for relevant information to this.