In Win XP Pro I have set up an excel 2007 workbook to link to a Word 2007 document to produce printable Latin/English flashcards (2 columns by 4 rows per sheet i.e. 8 flashcards). Each side of the sheet is printed in a separate mail merge.
On sheet 1 of the workbook I have the raw data including columns for card no, Latin word and English translation.
On sheet 2 I use the following formula to extract the Latin words from sheet 1
='Unit 1_Vocabulary'!F2
On sheet 3 I use the following formula to extract the English words from sheet 1 and change the order so that the correct English translation is printed on the back of each Latin word.
=IF(MOD('Unit 1_Vocabulary'!$A3,2)=0,'Unit 1_Vocabulary'!G2,'Unit 1_Vocabulary'!G4)
This formula calculates wether the card no. is odd or even and then extracts the correct English translation.
I have copied these formulas down the relevant columns and they seem to work correctly but with 1 slight problem. When the text is extracted it loses any formatting applied in sheet 1 i.e. text colour, bold, italics etc. Is there a way to retain formatting or is there a better way to set up the workbook to do this task, I don’t know a lot about vba?
On sheet 1 of the workbook I have the raw data including columns for card no, Latin word and English translation.
On sheet 2 I use the following formula to extract the Latin words from sheet 1
='Unit 1_Vocabulary'!F2
On sheet 3 I use the following formula to extract the English words from sheet 1 and change the order so that the correct English translation is printed on the back of each Latin word.
=IF(MOD('Unit 1_Vocabulary'!$A3,2)=0,'Unit 1_Vocabulary'!G2,'Unit 1_Vocabulary'!G4)
This formula calculates wether the card no. is odd or even and then extracts the correct English translation.
I have copied these formulas down the relevant columns and they seem to work correctly but with 1 slight problem. When the text is extracted it loses any formatting applied in sheet 1 i.e. text colour, bold, italics etc. Is there a way to retain formatting or is there a better way to set up the workbook to do this task, I don’t know a lot about vba?
Last edited by a moderator: