Getting data from another excel file

[Union70]

Union70 (e-mail address removed) wrote in message
Does anyone know how to create an Excel spreadsheet that will read
another Excel spreadsheet and will certain data in the new one?
For example:
File 1:
A1: Name
B1: Amount
C1: Chargeoff
D1: Current Balace

A2: Joe Smith
B2: 141.28
C2: 5.00
D2: 136.28

A3: Jane Doe
B3: 100.00
C3: 100.00
D3: 0.00

A4: Eric Yellow
B4: 1.00
C4: 0.00
D4: 1.00

End of File 1

File 2:
A1: Name
B1: Amount
C1: Chargeoff
D1: Current Balace

A2: Joe Smith
B2: 141.28
C2: 5.00
D2: 136.28

A3: Eric Yellow
B3: 1.00
C3: 0.00
D3: 1.00

End of File 2

Thanks,
John-


John,the question is not clear to me.What exactly you want.


Rajeev

This is the data in the First File:
Row Number Column A Column B Column C Column D
1 Name Amount Chargeoff Current
Balace
2 Joe Smith 141.28 5.00
136.28 <-- (B2-C2)
3 Jane Doe 100.00 100.00
0.00 <-- (B3-C3)
4 Eric Yellow 1.00 0.00
1.00 <-- (B4-C4)
End of File.

In a File 2 I would like to have File 2 read data from File 1 and
populate certain data.
This is the data in the File 2:
Row Number Column A Column B Column C Column D
1 Name Amount Chargeoff Current
Balace
2 Joe Smith 141.28 5.00
136.28 <-- (B2-C2)
3 Eric Yellow 1.00 0.00
1.00 <-- (B3-C3)
End of File.
I would like to have File 2 only have data when Column D from File 1
has a number greater then 0.00. I hope this helps.

Thanks,
John