Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 2nd 05, 02:17 PM
Union70
 
Posts: n/a
Default Getting data from another excel file


RAJEEV CHADHA Wrote:
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


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


--
Union70

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I transfer data in a pdf file into an excel workbook? CBooze1969 Excel Discussion (Misc queries) 2 April 19th 05 04:18 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM
insert data from one excel file into another Leonard Excel Discussion (Misc queries) 1 December 2nd 04 12:35 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017