Union70 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