Linking Sheets

[visible2you]

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

(2) 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.

Excel version: 2003 max
Macro preferred: No
VBA Preferred: Yes

[visible2you]

Looking for

[Chabu]

It is unclear what you have now and what you want.
Please provide an example of the existing situation and an explanation on what you want to achieve.

[visible2you]

Please refer this sheet for more details.

[CatDaddy]

are you joking?
...

[visible2you]

How can I import multiple CSV sheets into one Excel Sheet? I can do so by defining rows which I will reserve for each CSV file. Then I will delete empty rows between these CSV files (if any exists).

I will also ensure that while importing csv files, each row will contain CSV file name at end of row. So, lets wait for VBA to do this.

[visible2you]

are you joking?
...

This discussion is 100% different from another.

[CatDaddy]

not really...and i wish you wouldnt put links to your question in everyone else's threads too...

[visible2you]

not really...and i wish you wouldnt put links to your question in everyone else's threads too...

please ... I will agree with your point.