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.
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.