Hello everyone,

From an excel database, I fill in a first template (in attachment). Nevertheless, sometimes blocks overlap (in attachment) and I need to move these ones manually.



Thus, my question is the following one : how can I automatize the displacement of these blocks ? For instance, always keeping 2cm between the bottom of the block above and the top of the block below ?

Thanks in advance for your answers

Antoine ANDRE

Attached Images

	first template.png (81.9 KB, 16 views)
	overlap.png (95.6 KB, 16 views)

You're evidently using a variety of textboxes, etc. Layout relationships would be better maintained via a single multi-column/row table.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You are totally right !
Nevertheless, is there a way to link blocks by constraints ?

You might try grouping the affected textboxes so they won't change whatever overlap you start with.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]