help.jpgHi everyone and thank you for reviewing my question,

I am new to VBA but on a daily basis, I work with Excel. I take transcripts of representatives from different companies, break up what they say and analyze individual sentences in Excel. I thought I was done with one company, but we had an additional interview afterwards. There are about 40 different sheets; each question gets its own sheet. I have included a picture to show what I am trying to do.

I need to do two things:

A) I need to copy column G to every single worksheet. I put in another VBA to copy a blank column to all worksheets, but I need the title to transfer over (I realize I can do this manually but it would be nice to know an easier way for future reference)

B) I need to copy Column P to update the fact that it is now 14 companies and not 13.

Can anyone help me?

Thank you so much!!!!!!!!!!!