translate

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

Good morning. I would like to translate words or phrases / texts as it is possible to do with the google translator by setting the basic language (column a) and the languages to use for translation (column b) by entering the words or phrases (base language) in the cells from cell c1...

Hi, Im looking to translate this code into the worksheet_calculate listener as advised by members, however my lack of vba knowledge is getting the way. Is there anyway that can rewrite this code so it works in the calculate listener. Thankyou in advance!! Private Sub Worksheet_Change(ByVal...

Hello: I have what has turned into a complicated, but nice workbook, at least for our purposes, thanks to some direction from all of you. It is a project plan workbook with a GANTT chart that is pulling from 2 SQL databases and 4 other workbooks located on the network to update all of its...

I am hoping that one of you can help me with using the google translator API in Microsoft Excel. I have an excel file with about 35k rows. I am trying to build a macro where it takes everything in Excel column B, and translates it to column C. Does anyone know how to due this?

Is there a option that forces all your email or as you open a spreadsheet in English that can translate to Dominican Republic language? Thanks, Bears3898

I created a formula that works perfectly! This formula will count the amount of people on a list by counting the characters in column A, which is number 1- ?. Is there a way to translate this to VBA? Note: - the minus 9 and plus 9 represent the count (1-9 that I don't want to divide by.. it's...

I have a database which I have to enter about 5K line items in a specific format. I am not sure how to translate my raw data into the acceptable format. I have only moderate Excel skills, and know little about macros/VBA. Any help is greatly appreciated! Current format: <tbody> Customer/Fcst...

Hi All, Thanks in advance for any help you can give. I have a form in which i have the following formula linking a cell to another workbook to extract a value using the formula: =IFERROR(IF((INDEX(FIPCDNumber1,MATCH(PID,PIDFIP2,0)))=0,"",(INDEX(FIPCDNumber1,MATCH(PID,PIDFIP2,0)))),"")...

Hello, I have an Index/ Match code that basically cross references values in a table to give a numerical output and need help translating it into VBA. Here is the original code: =INDEX(T2:AH14;MATCH(B7;S2:S14;0);MATCH(B15;T1:AH1;-1)) Range of Outputs is T2:AH14 Table Header/ Column is...

I want to create a translation of script using excel. Whether this involves VBA or not, I don't know. Please look at the image to see the type of project I'm trying to create.

I am applying a formula from one existing project to a new project with similar data, but need to understand the formula so that I may see if any changes must be made to accomodate the new project...

I am new to PowerPivot but surprisingly impressed. I am currently doing a BI rationalization for reporting tools. I have an extensive background in Cognos and would like to know if PowerPivot/excel can translate an english report to a french report? If not I assume you make a copy of the english...

Hi, I have a large spreadsheet with a lot of data that is in Spanish. Is there any way or any code etc that would translate the whole spreadsheet to English? Thanks.

Hi Guys, I need a formula that can translate a color cell to a word. For example, cell A1 is color red, in cell B1 it should write "Late". Or in cell A2 is green so it will write "on time in" in cell B2 and so forth. Thanks guys, Hope you can help me with this.

Hi everyone, I am looking for a solution which will help me to change/tanslate values (Chinese caracters) into English and save the files into another directory. I already know which caracters correspond to which string in English. The values to be changed are in all columns and there are up...