Copying data from one excel to another programitically.

%3CLINGO-SUB%20id%3D%22lingo-sub-1715801%22%20slang%3D%22en-US%22%3ECopying%20data%20from%20one%20excel%20to%20another%20programitically.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715801%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%20have%20two%20excels%20say%20Excel%20A%20and%20Excel%20B.%3CBR%20%2F%3E%3CBR%20%2F%3EExcel%20A%20is%20used%20by%20some%20application%20.%3CBR%20%2F%3EExcel%20B%20having%20data%20that%20is%20modified%20by%20another%20application.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20data%20in%20Excel%20A%20will%20get%20modified%20as%20soon%20as%20excel%20B%20data%20updated%20for%20few%20rows%20and%20columns.%20For%20e.g.%20suppose%20in%20Excel%20B%2C%20Data%20of%20Row%205%2C%20column%206%20updated%20then%20corresponding%20data%20will%20be%20updated%20at%20excel%20A%20also.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20this%2C%20I%20simply%20made%20a%20refrence%20of%20Excel%20B%20on%20excel%20A%20and%20it's%20working%20fine%20when%20both%20excel%20are%20placed%20at%20window%20folder%20and%20open.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%2C%20I%20want%20to%20place%20file%20at%20one%20drive%20and%20want%20excel%20A%20will%20get%20updated%20as%20soon%20as%20excel%20B%20data%20changes%20without%20opening%20any%20of%20files.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20suggest.%3CBR%20%2F%3E%3CBR%20%2F%3EAmit%20Srivastava%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1715801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715819%22%20slang%3D%22en-US%22%3ERE%3A%20Copying%20data%20from%20one%20excel%20to%20another%20programitically.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715819%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20by%20Excel%20A%20%26amp%3B%20B%2C%2C%20are%20they%20Workbooks%20or%20Sheets%20%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715820%22%20slang%3D%22en-US%22%3ERE%3A%20Copying%20data%20from%20one%20excel%20to%20another%20programitically.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715820%22%20slang%3D%22en-US%22%3EExcel%20A%20is%20a%20excel%20sheet%20A%20and%20having%20Worksheet%20A.%3CBR%20%2F%3EExcel%20B%20is%20a%20excel%20sheet%20A%20and%20having%20Worksheet%20B.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20when%20data%20in%20Worksheet%20B%20of%20Excel%20B%20is%20updated%20%2C%20it%20will%20get%20updated%20in%20Worksheet%20A%20of%20Excel%20A.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3EAmit%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715822%22%20slang%3D%22en-US%22%3ERE%3A%20Copying%20data%20from%20one%20excel%20to%20another%20programitically.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715822%22%20slang%3D%22en-US%22%3EExcel%20A%20is%20a%20excel%20sheet%20A%20and%20having%20Worksheet%20A.%3CBR%20%2F%3EExcel%20B%20is%20a%20excel%20sheet%20B%20and%20having%20Worksheet%20B.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20when%20data%20in%20Worksheet%20B%20of%20Excel%20B%20is%20updated%20%2C%20it%20will%20get%20updated%20in%20Worksheet%20A%20of%20Excel%20A.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3EAmit%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Hi,
I have two excels say Excel A and Excel B.

Excel A is used by some application .
Excel B having data that is modified by another application.

I want data in Excel A will get modified as soon as excel B data updated for few rows and columns. For e.g. suppose in Excel B, Data of Row 5, column 6 updated then corresponding data will be updated at excel A also.

For this, I simply made a refrence of Excel B on excel A and it's working fine when both excel are placed at window folder and open.

Now, I want to place file at one drive and want excel A will get updated as soon as excel B data changes without opening any of files.

Please suggest.

Amit Srivastava
3 Replies
Highlighted
What do you mean by Excel A & B,, are they Workbooks or Sheets ??
Highlighted
Excel A is a excel sheet A and having Worksheet A.
Excel B is a excel sheet A and having Worksheet B.

I need when data in Worksheet B of Excel B is updated , it will get updated in Worksheet A of Excel A.

Thanks
Amit
Highlighted
Excel A is a excel sheet A and having Worksheet A.
Excel B is a excel sheet B and having Worksheet B.

I need when data in Worksheet B of Excel B is updated , it will get updated in Worksheet A of Excel A.

Thanks
Amit