Greetings all,
I'm hoping to get a bit of assistance, I'm new to macros, but I'm hoping they will assist me with this project I have to do for work. I have about 80 word documents to review and I need to copy all items that have a red cross against an operation (refer below), in all these documents and consolidate them into one new excel spreadsheet.
Is there a way to create a macro, that when activated, will review the word document, find operations that have this red cross (Located in a field called NA) then copy the whole line into an excel spreadsheet?
We are using word and excel 2016.
Any assistance, would be greatly appreciated.
I'm hoping to get a bit of assistance, I'm new to macros, but I'm hoping they will assist me with this project I have to do for work. I have about 80 word documents to review and I need to copy all items that have a red cross against an operation (refer below), in all these documents and consolidate them into one new excel spreadsheet.
Is there a way to create a macro, that when activated, will review the word document, find operations that have this red cross (Located in a field called NA) then copy the whole line into an excel spreadsheet?
We are using word and excel 2016.
Any assistance, would be greatly appreciated.
