Results 1 to 5 of 5

Thread: Update data from closed workbook with sumif formula

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 11-02-2011, 02:58 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    I accidently delete my earlier post.

    It can be done using INDIRECT function. However, to work with INDIRECT the other workbook must be open.

    PFA.
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro To Update Data in Cell Based On Value In Adjacent Cell
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 05-30-2013, 07:28 PM
  2. SumIf Formula Addition Based On AlphaNumeric Criteria
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 04-07-2013, 05:11 PM
  3. Compiling Workbook Data..
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 4
    Last Post: 01-23-2013, 01:21 PM
  4. Merging Data from many workbooks in to one workbook
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 14
    Last Post: 10-10-2011, 11:26 AM
  5. Split Closed Workbook into Multiple Workbooks Using ADO
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 10-02-2011, 08:34 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
  •  

Forum Rules