HELP If range equals

  • Thread starter Thread starter stacia
  • Start date Start date
S

stacia

When Department changes I need to insert the ADDRESS below the
Account-Institution Business Office. For instance if department = 883, go
to Account-Instittion business office and if = blank get address abc

123 Company
500 Thompson Rd.
Detroit, MI 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
 
Stacia can you please fill in your example what you need written and where? I
am not sure I understand what you need to accomplish.
 
If Account - Institution Business office is blank
Insert the address associated in the line below the title
The lines will vary often, and it has to do this for multiple pages each
with a different dept & address.
 
Back
Top