Aug 30 2017 07:02 PM
Excel spreadsheet with 2 tabs.
One titled : rawdata
another titled : automation
I need to copy some of the columns in rawdata to automation on a live basis.
In google the code for one of the columns is :
={ "Cruise Date" ;rawdata!C2:C}
Cruise Date being the title of the column.
rawdata being the tab to look at.
C2:2 being the column and row to start in and keep looking in.
This code doesn't work with Excel.
Can someone tell me what will work?
Customer Service says they don't touch code. ( I think its because they barely know what they are doing anyway, let alone add code to it!)
Is there a webpage that shows code examples so I can rewrite my previous codes to work with Excel?
What started as a "lets see if this is a better option" has turned into a nightmare...been on the phone with them all day long. One guy helps, another claims they can't help with that. Insane, but not giving up until I know for sure if this is even a option for us.
Aug 30 2017 07:51 PM
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.
Aug 31 2017 03:21 AM
SolutionHi 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-522a1f0..., but quite high level.
Nov 29 2021 05:24 PM
Aug 31 2017 03:21 AM
SolutionHi 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-522a1f0..., but quite high level.