Hi,
I am looking to create a macro which would look into 2 different excell spreadsheets and update one with information from another.
These spredsheets have different formatting and will always be different as they are generated by different sources however both of the contain data which is related to unique ID numbers. The data is stored in rows
Spreadsheet A
contains
ID Column, Cost Column and many others
Spreadsheet B
contains
ID Column, Target Column
I need to take Cost info from Spreadsheet A based on ID into Target Column (into correct Row) in spreadsheet B replacing the value there with cost data in following format ( 'data )
Understanding that these columns will differ from spreadsheet to spreadsheet I would like macro to prompt to specify target columns and then gather data from the same row where ID have matched.
Could anybody provide pointers in terms of how to approach this problem?
Regards
I am looking to create a macro which would look into 2 different excell spreadsheets and update one with information from another.
These spredsheets have different formatting and will always be different as they are generated by different sources however both of the contain data which is related to unique ID numbers. The data is stored in rows
Spreadsheet A
contains
ID Column, Cost Column and many others
Spreadsheet B
contains
ID Column, Target Column
I need to take Cost info from Spreadsheet A based on ID into Target Column (into correct Row) in spreadsheet B replacing the value there with cost data in following format ( 'data )
Understanding that these columns will differ from spreadsheet to spreadsheet I would like macro to prompt to specify target columns and then gather data from the same row where ID have matched.
Could anybody provide pointers in terms of how to approach this problem?
Regards