visible2you
08-31-2011, 12:02 PM
Hi,
I am working to link data between two excel work books, say BookM.xls, BookC1.csv, BookC2.csv, BookC3.csv
If any cell value of
Column A, C, E of BookC1.csv,
Column A, C, E of BookC2.csv,
Column A, C, E of BookC3.csv
is changed or added,
then
(1) On clicking "refresh" button of BookM, all csv files are imported and "stacked" into Column A, C, E of sheet2 of BookM in the stack order of BookC1.csv, BookC2.csv, BookC3.csv :think:
(2) :mkay Sheet1 of BookM has primary key in Column A and foreign key in Sheet2 of BookM.
So, Sheet1 should use Primary key to update values in Column C and E using foreign key present in Sheet2 of Book M and using values present in Col C and E of Sheet 2. :mkay
Excel version: 2003 max
Macro preferred: No
VBA Preferred: Yes
I am working to link data between two excel work books, say BookM.xls, BookC1.csv, BookC2.csv, BookC3.csv
If any cell value of
Column A, C, E of BookC1.csv,
Column A, C, E of BookC2.csv,
Column A, C, E of BookC3.csv
is changed or added,
then
(1) On clicking "refresh" button of BookM, all csv files are imported and "stacked" into Column A, C, E of sheet2 of BookM in the stack order of BookC1.csv, BookC2.csv, BookC3.csv :think:
(2) :mkay Sheet1 of BookM has primary key in Column A and foreign key in Sheet2 of BookM.
So, Sheet1 should use Primary key to update values in Column C and E using foreign key present in Sheet2 of Book M and using values present in Col C and E of Sheet 2. :mkay
Excel version: 2003 max
Macro preferred: No
VBA Preferred: Yes