+ Reply to Thread
Results 1 to 3 of 3

How to Update Master Bank Sheet with Indvidual Banks Sheets

  1. #1
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    How to Update Master Bank Sheet with Indvidual Banks Sheets

    Dear All,
    I have 3 banks accounts with 3 difference banks, what i need is a Master Bank Sheet in which i can monitor the consolidated balances and statements, suppose if i enter any entry in one bank it will update in the Master Bank Sheet also (refer attached file for more info).
    Attached Files Attached Files

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: How to Update Master Bank Sheet with Indvidual Banks Sheets

    hi there,

    have a look at the attached - i hope it serves your need. the solution uses MS Query and has to be placed in the folder "C:\Downloads" in order to work.

    use the key combination of CTRL + ALT + F5 to Refresh your data, after enabling Data Connections (if prompted to do so).

    i have had to make a few changes - the column headers were not jiving with MS Query, so i had to change them.

    on the Master tab, the Balance column is a post-query calculated column.

    in case you want to change the file_name and/or folder_path, you will have to mildly tweak the query. here is how to get there (">" means press one after the other; "+" means press together):

    ALT > A > O

    ALT + P

    ALT + D

    ALT + M

    copy the highlighted query onto notepad and just find/replace the file_name and folder_path. then, paste it back there and save, then refresh.

    holler back in case of any issue.

    UPDATE

    please see the attached file.
    Attached Files Attached Files
    Last edited by icestationzbra; 04-30-2014 at 10:33 AM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to Update Master Bank Sheet with Indvidual Banks Sheets

    Dear Sir,

    Thank you for the solutions, but the balance column is not matching, please update the balance column as it is important for me

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 04-14-2014, 04:11 AM
  2. Replies: 0
    Last Post: 01-14-2011, 12:01 PM
  3. Update sheets from master sheet
    By amzg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2009, 04:13 PM
  4. Update master sheet from sub sheets
    By y_not in forum Excel General
    Replies: 1
    Last Post: 04-29-2009, 09:58 AM
  5. one master sheet and four update sheets?
    By jodenice in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2008, 07:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1