Paste from cell into shape and move shape

[chrisellis250]

Hi all,

As shown on the attached I have 3 sheets.

Based on the data in "Co-location" sheet, the Cell in E7 in "Info" is populated based on the formulae in it.

What I am trying to do is automate the process of copying the text from E7 in Info (not the formula but the result of the formula) in to the shape, keeping source formatting.

Then I want the shape from "Info" and the adidas logo pasting at the top of "co-location" sheet as shown in the "Co-location (How i want it)" sheet - i.e. in those positions.

I have tried recording the process, but it does not work.


Any ideas?


Kind Regards,

[bsalv]

by using the camera tool ?
https://www.youtube.com/watch?v=5XULAGj4OZA
The camera in "co-location" shows the realtime content of G1:U6 in "info"
So modify a cell in info for example U1
(afterwards you can modify border, background, .... of the camera)