Hi Ian,



There have been multiple macros discussed in this thread, so I don't know which approach you're trying to take. It would also make it easier to diagnose the issue if you could attach a document to a post with some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

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

Hi Paul

Thank you for your prompt response. It was the most last piece of coding posted by yourself (04/26/2013), I selected this one as I will always need the top and bottom rows to show. Initially I tried to trigger the deletion from the detail contained in the second row (headed up purchase amount), each of these fields has been bookmarked (e.g. LA1 - LA10) however that seemed to be extremely complicated, hence trying to replicate this section. But even this seems to be beyond me!

I've attached a duplicate of the table in question, any light you can shed would be most welcome!

Attached Files

Macro Template.doc (54.0 KB, 16 views)