LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Raya
 
Posts: n/a
Default join 2 spreadsheets

I have one file with fields
F1 F2 F3 ....
1 2 31
2 3 32
3 4 33
and I have to update it from another file with fields
F1 F3
1 51
3 53
where F1 is the key field
as a result I must receive:
F1 F2 F3 ....
1 2 51
2 3 32
3 4 53
How can I do it?




 
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
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
How to create a default footer for all my spreadsheets? Kary P. Excel Discussion (Misc queries) 3 June 1st 05 12:45 AM
Linking between spreadsheets does not work unless I have both spr. RCppe Excel Discussion (Misc queries) 2 March 30th 05 12:37 AM
Compare two spreadsheets to find differences. Toby Excel Discussion (Misc queries) 1 March 29th 05 01:19 AM


All times are GMT +1. The time now is 08:43 AM.

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

About Us

"It's about Microsoft Excel"