What I want to do: Combine english and french data sheets to a bilingual sheet so when I need to update contact information it's only in one place.
I am working with a workbook used as a contact search tool. The first sheet is an index page that allows users to select what language you want the information in, the 2nd sheet is all the contact information data in English, the 3rd sheet is all the same information in french. I would like to combine sheet 2 and 3 to create a bilingual tab rather than a separate one. The last column (D) is the same on both data sheets but the other columns are different due to translation.
When a user accesses the workbook...
1. First, the user chooses English or french
2. Another box appears with options to choose from that corresponds to the columns in the data sheets (city, sector, department)
3. When the selections are all made the appropriate contact info is shown. (there are filters set on the data sheets to find the right person)
***the user still needs to be able to select what language they are using the search tool in once it's in one sheet.
Basically, the new sheet would have columns: A(en), A(fr), B(en), B(fr), C(en), C(fr), D
I am working with a workbook used as a contact search tool. The first sheet is an index page that allows users to select what language you want the information in, the 2nd sheet is all the contact information data in English, the 3rd sheet is all the same information in french. I would like to combine sheet 2 and 3 to create a bilingual tab rather than a separate one. The last column (D) is the same on both data sheets but the other columns are different due to translation.
When a user accesses the workbook...
1. First, the user chooses English or french
2. Another box appears with options to choose from that corresponds to the columns in the data sheets (city, sector, department)
3. When the selections are all made the appropriate contact info is shown. (there are filters set on the data sheets to find the right person)
***the user still needs to be able to select what language they are using the search tool in once it's in one sheet.
Basically, the new sheet would have columns: A(en), A(fr), B(en), B(fr), C(en), C(fr), D