its crashing at



oNewDoc.SaveAs FileName:=strPath, FileFormat:=12, AddToRecentFiles:=False

the other thing is how i suppose to run this macro

should i have both windows open 1) with the master data and the 2nd window blank so i t can extract from 1 and paste in the 2nd one.

btw i'm using word 2000 so DOCX i believe is for new version of files.

It would have been much easier if the DO LOOP code was just fixed in the file that i attached.

The macro that you have written is very sophisticated and advance for my knowledge.

Thanks a lot though for your help.

Here is the output that i'm looking for

attached are both 1) macro file 2) the data file.

Thanks


Mexco Energy Corporation (MXC) Total Revenue 2,525.363 2,421.792 3,390.005
the Rubicon Project, Inc. (RUBI) Total Revenue 278,221 248,484 125,295
Liberty All-Star Growth Fund, Inc. (ASG) Total Revenue 985.629 28,621.59 13,942.108
Partner Communications Company Ltd. (PTNR) Total Revenue 921,000 1,057,000 1,131,000
SITO Mobile, Ltd. (SITO) Total Revenue 29,426.955 12,805.19 15,809.467
Echelon Corporation (ELON) Total Revenue 32,385 38,804 38,730
TerraForm Global, Inc. (GLBL) Total Revenue 214,317 124,116 39,449
Juniper Pharmaceuticals, Inc. (JNP) Total Revenue 54,573 38,287 33,393
Vivint Solar, Inc. (VSLR) Total Revenue 135,167 64,182 25,258

Attached Files

	macro with data.doc (105.0 KB, 12 views)
	output file.doc (20.0 KB, 10 views)