Currently, I have about 200 work instructions each on varying from 2-30 pages which were created in excel throughout the years. Work instructions are documents explaining how to perform specific task, in my case, in a manufacturing environment.

The problem I have is each one of these documents are in a template which was created in excel and I need to convert them to the new template in excel. I have been copying and pasting page by page of pictures, document information, and instruction. Very time consuming process.

Fortunately, the new and old formats are very similar; the new one has a couple added and rearranged cells for document control.

After researching and talking with peers, they have mentioned that I should create a macros to pull the pictures and words from the old format and dump them into the new format.

I am experienced with excel but very little to no experience with macros and visual basic.
Any suggestions or thoughts would be appreciated.

Thanks,

CRV_MANENG