| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After importing FIND en CHANGE corresporending value
Hello,
I have imported data from Access to Excel. Now I want to modify the values which have corresponding ID's. Does anyone have allreadt solved this problem. Please help me out i'm running out of time. Example: Sheet 1 Sheet Import ******** ************* ID LineID AM ID LineID AM -- ------ --- -- ------ --- 01 100 562 01 100 500 (562-500) 01 101 578 01 101 564 (578-564) 02 100 714 02 100 650 (714-650) 03 500 471 03 500 400 (471-400) 03 501 897 03 501 579 (897-579) AM of Sheet 1 need's to be changed by AM of Import Sheet!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel references change when importing data | Excel Discussion (Misc queries) | |||
| How do I change the default location when Importing data? | Excel Discussion (Misc queries) | |||
| How do I change the date format when importing a txt file? | Excel Worksheet Functions | |||
| How Change default "look in" location in EXCEL for Importing Exte. | Excel Discussion (Misc queries) | |||
| How do I change the default location for importing text files? | Excel Discussion (Misc queries) | |||
Linear Mode
