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.
Hello,
={ "Cruise Date" ;rawdata!C2:C} is not a valid Excel formula.
Where does the data in the sheet "rawdata" come from? Is it entered manually? If so, you can use VBA to copy new data to another sheet. Is it from a data feed? In that case you still need VBA, but the solution will be a lot more complex.
Please clarify.