PDA

View Full Version : Linking Sheets



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

visible2you
09-01-2011, 11:47 AM
Looking for :help
:cloud9:

Chabu
09-01-2011, 02:23 PM
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
09-01-2011, 02:46 PM
:help Please refer this sheet (http://www.vbaexpress.com/forum/showthread.php?t=38863) for more details.

CatDaddy
09-01-2011, 02:51 PM
are you joking?
...

visible2you
09-01-2011, 02:52 PM
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
09-01-2011, 02:56 PM
are you joking?
...


This discussion is 100% different from another (http://www.vbaexpress.com/forum/showthread.php?t=38863).

CatDaddy
09-01-2011, 03:07 PM
not really...and i wish you wouldnt put links to your question in everyone else's threads too...

visible2you
09-01-2011, 03:15 PM
not really...and i wish you wouldnt put links to your question in everyone else's threads too...
:help please ... I will agree with your point.