Getting data from another excel file

U

Union70

Does anyone know how to create an Excel spreadsheet that will rea
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,
Joh
 
R

RAJEEV CHADHA

Union70 said:
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
Click to expand...


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


Rajeev
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting data from another excel file 0
Need to have data in one column 1
Protecting user from changing previous data 5
Looking to added up based on a character from cell range 1
Sorting 12
Need help calculating probabilities 7
Vlookup and multiple data 5
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1

Top