responsibility

Hello, I have the below text that I would like to extract the person's name (highlighted in bold) who is responsible for "Markup Changes" .. essentially this is the second instance of "responsibility of" Cell text looks like this variable text (Responsibility of: surname, firstname, due...

Thanks for any help! I am trying to speed up a process for my job where instead of copying and pasting all of the values into one field, I can run a macro to put it all into one field for me. How the field comes to me is with a merged cell of "Responsibility / Duty:" and all the fields to the...

Hello - I have a spreadsheet that has VBA to sum the final row. Range("B" & LastRow + 1).Formula = "=(SUM(B10:B" & LastRow & "))" This worked perfectly until areas of responsibility subtotals were added to the report. For example Oncology 20...

I am a definite newbie to the VBA. I have learned a lot over the past couple of years but I really have only one job responsibility that requires it but it is a big one. I have lots of information/forms/databases inside of one Excel File. I would like to know what else I could do to make it...