Please attach a copy of the Word document you're trying to run the macro on. It is impossible to be sure from either your original sample or the content of your Excel workbook how the data appear in your Word document. I had to make some assumptions for the macro that may or may not have been valid.

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

Hi, thanks for the reply.

I've attached a copy of a Word document, this is data straight from the Excel file I posted yesterday. This file is the smallest of 5, but the data in each is presented in the same format.

The data itself was provided to me in Excel, but 3 of the files exceed the 11k+ rows Excel permits, and I recalled that Word would be able to handle all the data, so I've just used the 'open with' feature.

The ultimate aim is for the data to be used in Excel, but spilt into seperate tabs one for each user id.

Hope this helps


Ballst

Attached Files

WORD1case_audit_oc6.doc (10.0 KB, 9 views)