Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data
If possible (willing) please help.
I am trying to copy data from one file into another. I have copied code from various sites and tried to manipulate that code to do what I want it to do. No success, as I am a novice code writing understanding what is happening and how to change it is the problem. I need your help if possible please. Here is what I would like to happen. The base or main file is called RMA.xls. The other file which is e-mailed to me is called RMA LMR.xls. Columns A to K have the same headings in the two files. In the RMA.xls file Columns L to P are different to RMA LMR.xls and unique. RMA LMR.xls has Columns L to M that are different and unique to this file. Column B has the list of unique ID for both files. What must happen is as follows: 1: RMA.xls. is open and RMA LMR.xls must be found and selected to be opened. 2: Compare the two ID keys to see that they correspond. RMA LMR.xls to RMA.xls. (RMA.xls.is the base). 3: Copy the data in Column L and M from RMA LMR.xls. to RMA.xls, ensuring that the relevant Ids match exactly. 4: Close RMA LMR.xls. 5: Save RMA.xls. If you are able please help. Thank you and best regards Max |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data (Tutor/Teach)
Hello All,
Would someone be prepared to teach me how to do what I need in my question? Thank you and best regards Max "Max" wrote: If possible (willing) please help. I am trying to copy data from one file into another. I have copied code from various sites and tried to manipulate that code to do what I want it to do. No success, as I am a novice code writing understanding what is happening and how to change it is the problem. I need your help if possible please. Here is what I would like to happen. The base or main file is called RMA.xls. The other file which is e-mailed to me is called RMA LMR.xls. Columns A to K have the same headings in the two files. In the RMA.xls file Columns L to P are different to RMA LMR.xls and unique. RMA LMR.xls has Columns L to M that are different and unique to this file. Column B has the list of unique ID for both files. What must happen is as follows: 1: RMA.xls. is open and RMA LMR.xls must be found and selected to be opened. 2: Compare the two ID keys to see that they correspond. RMA LMR.xls to RMA.xls. (RMA.xls.is the base). 3: Copy the data in Column L and M from RMA LMR.xls. to RMA.xls, ensuring that the relevant Ids match exactly. 4: Close RMA LMR.xls. 5: Save RMA.xls. If you are able please help. Thank you and best regards Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data from 2 data excel sheets | Excel Discussion (Misc queries) | |||
Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
Merging data | Excel Programming | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming |