View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe K. Joe K. is offline
external usenet poster
 
Posts: 41
Default Copy Data From Worksheet to Another Worksheet


I would like a Excel VBA script to copy the data from Worksheet T1 to
Worksheet T2. Columns A and B uniquely identify the records for Worksheet T1
and Worksheet T2. I would like the script to populate Column K,L,M,and N from
Worksheet T2 the using the Columns C,D,E and F from Worksheet T1.

Please help me create this script.

Thanks,


Worksheet T1
Column A Column B Column C Column D Column E Column F
123 TENN 647 2389 IN 879
238 DALL 348 7148 OUT 1224
624 DENV 786 8909 IN 6478

Worksheet T2
Column A Column B Column K Column L Column M Column N
624 DENV
123 TENN
238 DALL

Desired Output: Worksheet T2
Column A Column B Column C Column D Column E Column F
624 DENV 786 8909 IN 6478
123 TENN 647 2389 IN 879
238 DALL 348 7148 OUT 1224