I see you are still posting in more than one group and even asking the same
question in the same group. This is NOT a good way to make friends here.
Also, you do not give the information as to where to FIND the info to copy
to your data. In the previous help I gave you the way to do this is clear.
Just apply those principles to this.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"stacia" wrote in message
...
When Department changes I need to insert the ADDRESS below the
Account-Institution Business Office:. Another option I have is that if
address = get new address from page 2. HELP

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ending 02/13/10
----------------------------------------------------------------
Account-Institution Business Office:

DEPT EMP.NBR EMPLOYEE NAME ADDRESS

883 27903 ROBERSON, JOE abc
883 119245 MUSIL, TODD E abc

883 Total
-----------------------------------------------------------------
Account-Institution Business Office:

DEPT EMP.NBR EMPLOYEE NAME ADDRESS

887 277878 MUMTAZ, MALIKAH def
887 352122 WHITING, BOBBI JO def

887 Total
-------------------------------------------------------
Account-Institution Business Office:

DEPT EMP.NBR EMPLOYEE NAME ADDRESS

893 197805 HOEL, JEFFREY S ghi
893 202426 YORK, TODD A ghi

893 Total
----------------------------------------------------------
Account-Institution Business Office:

DEPT EMP.NBR EMPLOYEE NAME ADDRESS

934 111806 FELDMANN, Mike jkl
934 137215 JAMES, MARK jkl

934 Total
-------------------------------------------------------------------------



Grand Total
--
Stacia