View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stacia stacia is offline
external usenet poster
 
Posts: 23
Default Copy and Paste based on criteria

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