Going round in circles here but I feel I am over thinking this or the right syntax just eludes me.
I have a Master spreadsheet with a Notes column and a another sheet with today's date and specific phrases that I choose. Instead of always manually copying and pasting these phrases or using concatenate as a worksheet formula so I can update the Notes in the Master, I just want a macro to run. I have a cell selected in the phrases sheet and a selected in the Master sheet and want to add the text from Phrases into the Notes cell in Master but results are not correct. Nrange picks up the text in oPhrases that's in the same ROW as the active cell in Master instead of the row with the selection box around it. Bascially, just concatenating except the row in both sheets will be variable. Thanks in advance for your help.
I have a Master spreadsheet with a Notes column and a another sheet with today's date and specific phrases that I choose. Instead of always manually copying and pasting these phrases or using concatenate as a worksheet formula so I can update the Notes in the Master, I just want a macro to run. I have a cell selected in the phrases sheet and a selected in the Master sheet and want to add the text from Phrases into the Notes cell in Master but results are not correct. Nrange picks up the text in oPhrases that's in the same ROW as the active cell in Master instead of the row with the selection box around it. Bascially, just concatenating except the row in both sheets will be variable. Thanks in advance for your help.
VBA Code:
Dim as Worksheet
Set ms = Worksheets("Master")
Dim ph as worksheet
Set ph = Worksheets("oPhrases")
Dim Mrange as Range
Dim Nrange as Range
Set Nrange = ph.Range("c" & selection.row) ' supposed to be the cell with the right phrase for this file.
Set Mrange = ms.Range("L" & selection.row) ' the current file in the Master I am working on
Mrange = NRange & " " & Mrange