Hello,

I need the following as a macro function.

If ColumnA= "Domain1",
then ColumnC = "english/" & ColumnB (whichever cell is next to the active cell)


I would like to use a Select Case Macro for this:
Case Domain1
english/Page

Case Domain2
french/Page2

Table
Column A Column B Column C
Domain1 Page
Domain 1 Page1
Domain 2 Page2


Final Table (Goal)
Column A Column B Column C
Domain1 Page english/Page
Domain 1 Page1 english/Page1
Domain 2 Page2 french/Page2