Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Data Update
How can i use macro to insert data from one workbook to another wookbook on a particular columns without affecting other columns. For example. A B C D NAMES ID COURSE NAME SCORES Kim 001 safety 60% Larry 002 Lighty 80% Buster 003 Wide 56% Both workbooks have these heading. I want "destination.xls" to pull only rows A and B(Names and ID) from the "source.xls." automatically everytime i open it and if "Kim" appear twice it should only pull one "Kim". I mean in case NAME "Kim" OR "ID" 001 Appear more than one time. Macro should only pick the first one that appear to DESTINATION.XLS file. please can anybody help me with this?. Thanks Appreciate your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Sharepoint Data in Excel | Excel Discussion (Misc queries) | |||
automatic data update | Excel Discussion (Misc queries) | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
Automatic data update | Charts and Charting in Excel | |||
automatic update of filtered linked data? | Excel Discussion (Misc queries) |