Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge 2 files
Dear All,
need ur help again. I have 2 file with different tables. for File A, i have customer Id, name for File B, i have customer Id, Address. now i want to merge 2 file become one. i want to insert address field automatically to file A and parameter customer Id file A = customer Id file B. can you teach me how to achieve that.... thanks reza |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge 2 files
You can use function"VLOOKUP" to achieve.
In file A, input Address, then use formula =vlookup(A2,fileB.xls!A:B,2,0), suppose your customer ID are in column A in both file A and file B, Name and address are in column B. Hope this can be of help. "reza" wrote: Dear All, need ur help again. I have 2 file with different tables. for File A, i have customer Id, name for File B, i have customer Id, Address. now i want to merge 2 file become one. i want to insert address field automatically to file A and parameter customer Id file A = customer Id file B. can you teach me how to achieve that.... thanks reza |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge 2 files
thanks alex....
"Alex" wrote: You can use function"VLOOKUP" to achieve. In file A, input Address, then use formula =vlookup(A2,fileB.xls!A:B,2,0), suppose your customer ID are in column A in both file A and file B, Name and address are in column B. Hope this can be of help. "reza" wrote: Dear All, need ur help again. I have 2 file with different tables. for File A, i have customer Id, name for File B, i have customer Id, Address. now i want to merge 2 file become one. i want to insert address field automatically to file A and parameter customer Id file A = customer Id file B. can you teach me how to achieve that.... thanks reza |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Two Files
Hi Reza,
There is a new PC software that you can use as a supplement to Microsoft Excel and Access. For one thing, it combines multiple files. Visit www.genresoftware.com and look at the pages Importing Files and Programming Instruction Set. Cheers, Reno reza wrote: merge 2 files 25-Jan-10 Dear All, need ur help again. I have 2 file with different tables. for File A, i have customer Id, name for File B, i have customer Id, Address. now i want to merge 2 file become one. i want to insert address field automatically to file A and parameter customer Id file A = customer Id file B. can you teach me how to achieve that.... thanks reza Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice C# .NET Windows Task Scheduler http://www.eggheadcafe.com/tutorials...task-sche.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
Merge 2 Files | Excel Discussion (Misc queries) | |||
Merge excel files | Excel Discussion (Misc queries) | |||
how do I merge two files? | Excel Discussion (Misc queries) | |||
MERGE 2 FILES | Excel Discussion (Misc queries) |