SOLVED

Code to copy data from one column to another in same workbook but different sheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-102249%22%20slang%3D%22en-US%22%3ECode%20to%20copy%20data%20from%20one%20column%20to%20another%20in%20same%20workbook%20but%20different%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-102249%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20spreadsheet%20with%202%20tabs.%3C%2FP%3E%3CP%3EOne%20titled%20%3A%20rawdata%3C%2FP%3E%3CP%3Eanother%20titled%20%3A%20automation%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20copy%20some%20of%20the%20columns%20in%20rawdata%20to%20automation%20on%20a%20live%20basis.%3C%2FP%3E%3CP%3EIn%20google%20the%20code%20for%20one%20of%20the%20columns%20is%20%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%7B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Cruise%20Date%22%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3B%3C%2FSPAN%3E%3CSPAN%3Erawdata!C2%3AC%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%7D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3ECruise%20Date%20being%20the%20title%20of%20the%20column.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Erawdata%20being%20the%20tab%20to%20look%20at.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EC2%3A2%20being%20the%20column%20and%20row%20to%20start%20in%20and%20keep%20looking%20in.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EThis%20code%20doesn't%20work%20with%20Excel.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3ECan%20someone%20tell%20me%20what%20will%20work%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3ECustomer%20Service%20says%20they%20don't%20touch%20code.%20(%20I%20think%20its%20because%20they%20barely%20know%20what%20they%20are%20doing%20anyway%2C%20let%20alone%20add%20code%20to%20it!)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EIs%20there%20a%20webpage%20that%20shows%20code%20examples%20so%20I%20can%20rewrite%20my%20previous%20codes%20to%20work%20with%20Excel%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EWhat%20started%20as%20a%20%22lets%20see%20if%20this%20is%20a%20better%20option%22%20has%20turned%20into%20a%20nightmare...been%20on%20the%20phone%20with%20them%20all%20day%20long.%20One%20guy%20helps%2C%20another%20claims%20they%20can't%20help%20with%20that.%20Insane%2C%20but%20not%20giving%20up%20until%20I%20know%20for%20sure%20if%20this%20is%20even%20a%20option%20for%20us.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-102249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-102307%22%20slang%3D%22en-US%22%3ERe%3A%20Code%20to%20copy%20data%20from%20one%20column%20to%20another%20in%20same%20workbook%20but%20different%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-102307%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Lalla%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActually%20Google%20Sheets%20doesn't%20copy%20one%20column%20to%20another%20whith%20this%20formula%2C%20what%20it%20do%20that's%20link%20target%20column%20to%20source%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%20there%20is%20no%20such%20formula%20which%20do%20the%20same%2C%20however%20you%20may%20link%20two%20columns%20(or%20ranges)%20manually%2C%20see%20for%20example%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.techwalla.com%2Farticles%2Fhow-to-link-columns%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.techwalla.com%2Farticles%2Fhow-to-link-columns%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20not%20exactly%20the%20same%2C%20but%20simular.%20In%20Google%20Sheets%20if%20you%20type%20something%20in%20target%20columns%20that's%20break%20you%20link%20at%20all.%20In%20Excel%20links%20will%20be%20on%20cell%20by%20cell%20basis%20-%20if%20you%20put%20something%20in%20target%20column%20you%20break%20link%20only%20for%20changed%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20general%20quite%20many%20is%20compatibel%20between%20Sheets%20and%20Excel%2C%20but%20not%20all.%20Here%20is%20some%20guidline%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSwitch-to-Excel-from-Sheets-54b2c938-1334-41c7-a43f-522a1f029294%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EAABAAA%3DDifferences%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSwitch-to-Excel-from-Sheets-54b2c938-1334-41c7-a43f-522a1f029294%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EAABAAA%3DDifferences%3C%2FA%3E%2C%20but%20quite%20high%20level.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-102261%22%20slang%3D%22en-US%22%3ERe%3A%20Code%20to%20copy%20data%20from%20one%20column%20to%20another%20in%20same%20workbook%20but%20different%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-102261%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%7B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Cruise%20Date%22%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3B%3C%2FSPAN%3E%3CSPAN%3Erawdata!C2%3AC%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%7D%20is%20not%20a%20valid%20Excel%20formula.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EWhere%20does%20the%20data%20in%20the%20sheet%20%22rawdata%22%20come%20from%3F%20Is%20it%20entered%20manually%3F%20If%20so%2C%20you%20can%20use%20VBA%20to%20copy%20new%20data%20to%20another%20sheet.%20Is%20it%20from%20a%20data%20feed%3F%20In%20that%20case%20you%20still%20need%20VBA%2C%20but%20the%20solution%20will%20be%20a%20lot%20more%20complex.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EPlease%20clarify.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

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. 

best response confirmed by Lalla Lilley (Occasional Contributor)
Solution

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-522a1f0..., but quite high level.

You could simply type
='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.