Ask Experts Questions for FREE Help !
Ask
    zatak's Avatar
    zatak Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Jul 20, 2010, 11:19 AM
    How to connect two excel files such that any updation in one also affects the other
    I want to connect two excel documents... such that any change in figures or updation in the first one refreshes the figures in the second one. Have to use macro code... but what and how?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 20, 2010, 02:46 PM

    Impossible to answer without seeing what you need.

    Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your two workbooks... make sure it's clear what should be connected where.
    zatak's Avatar
    zatak Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Jul 23, 2010, 06:04 AM
    I don't need to do that am trying to do the same stuff in access... need some modification in sql select code... how can I insert a new row in result dataset in query and in that dataset perform sum of a column of numeric such that its displayed in that new row created;query dataset created from a specific table?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect two excel sheets? [ 3 Answers ]

Hi Friends, I want to connect in such a way that whatever I will copy in source file should be copied automatically in target file. It would be great to get help from you.

How to connect cells in excel in sequence [ 1 Answers ]

How do you link cells from one sheet to another in a workbook if the cells are in a sequence? I use the formula ='Sheet1'!C2, etc. but entering the formula for each cell is tedious. Is there a faster way if the cells are in sequence?

Connect to Excel documents [ 2 Answers ]

Hello. I have two documents, one is connected to a database and the second isn't. I wan't to connect these documents, so the numbers in the second document refresh every time the first one do. In the first document the data is wrote vertically and in the second the data is wrote horizontally. ...

Excel files on the web [ 2 Answers ]

Hi, I would like to post my excel files on the web, so that users can open and view them. Do you know any web tools that I can use? Thanks!

Merging 2 Excel files [ 4 Answers ]

I've got a specialized Excel Form that we use to transcribe groups of records: Here's an example: http://catholicrecordsociety.org/projects/stjosephorphanasylum/volunteers.html (you need to have Macros Enabled) You'll see that the Card Tab is for entering Records and the Spreadsheet is...

View more questions Search