Need to copy values from other documents based on heading name and create a new document through VBA
Hi,
I my company i am working for a Department. This Department has 4 Divisions. Each Division will send their Weekly Highlights to My Department. I will select important topics from the 4 Word Documents which i recieved from Division and i place it in a new Document, this new document wil be send to the management.
For example Each Division has a Heading named
'Productivity & Improvement And Cost Savings'
'HRD22 Gain'
under that they may have a heading containing the word 'HRD22 Gain' like this. So i have to pick all the paragraph which contains the word 'Gain' in their heading which come under 'Productivity & Improvement And Cost Savings'. Similar to the Example i said i have some more headings and some more sub headings which i have to do.
Every week i am doing this repeated process. I like to automate this. Is it possible to write VBA code. Where i can get a similar example or forum which could guide me.
I think when i open a new document and run the macro - all the required headings & paragraphs will copied from the four divisions will be pasted in this newly opened document. The code should do this or any other suggestions please.