Copy/Paste Macro - Over Object

  • Hello,


    I'm not sure if this is possible, but I thought I'd ask and see if any feedback would help move this project along.


    I have this macro to copy/paste data from sheet1 to sheet2. However, it was requested that a form be placed into sheet2 from Microsoft Word. This form is too complex for Excel to handle and I imported it as an object. Is there any way to move the the "object" to the background and have this macro populate the cells required so that it would show on top of the object?


    Or perhaps I am missing a step that could properly port such a document into Excel that would allow a copy/paste macro to do its job?


    Thank you for any help!

  • Re: Copy/Paste Macro - Over Object


    Bump. Does anyone know how to perform such a request or if it's possible? I also considered adding the image as a footer, but can't manage to keep the footer in one place as it moves while the text in the cells move.