View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Evan_Robitaille via OfficeKB.com Evan_Robitaille via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Combine Two Worksheets

I have two files with the following columns:

FILE 1 FILE 2
A: User ID A: End User
B: First Name B: Name
C: Last Name C: SSN
D: Active User
E: Payment
F: Payment Total
G: Last Payment Date

The common field is Column A in both tables. I want to start with File 2 and
bring the contents of Column E in File 1 into File 2. My new file would then
be:
A: End User
B: Name
C: SSN
D: Payment (field inserted from File 1)

Thanks in advance for any help with this.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200905/1