Announcement

Collapse
No announcement yet.

Attention VBA/Excel experts

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Please Help Attention VBA/Excel experts

    I'm praying for help to accomplish something (VBA/Excel related).
    Here's a brief description, so ya'll can try to assist me or refer me to another brother who knows:

    Cell A1 contains a paragraph made of Hebrew words (They are Bible verses in Hebrew, so sometimes more than 254 characters long in each cell).
    Cell B1 contains a paragraph of English words (They are Bible verses in English, so sometimes more than 254 characters long in each cell).
    Column C contains a list of single Hebrew words.
    Column D contains the Strong's code for each of those Hebrew words.
    Column E contains a list of single English words.
    Column F contains the Strong's code for each of those English words.
    Finally, Column G contains a list of single words that will be replacing the English words with IF all criteria is met.
    (these words are transliterated single words).

    So, this is what I'm trying to do:
    IF a Hebrew word within the paragraph of cell A1, is the same as a Hebrew word found in the list in Column C,
    AND an English word within the paragraph of cell B1, is the same as an English word found in the list in Column E.
    AND the Strong's code for this word is the same in (both) Column D and Column F,
    THEN create a new paragraph (Bible verse) in a (new) Column H, which will be a combination: Rendering the existing English words from B1 that did not meet this criteria, but rendering the transliterated words from Column G when all criteria is met.
    I'm not sure Excel will support this task because of the 254 character issue, but since I don't know VBA, I figure getting help in Excel will be easier.
    Thanks for trying to help and especially for helping me pray for the solution to this.
    Praying to the Father: The love of JESUS help us walk in Your love, Amen.
    Alex
Working...
X