Results 1 to 7 of 7

Thread: updating formulas

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte happy_smiler1's Avatar
    Join Date
    Aug 2012
    Posts
    67
    Articles
    0
    Excel Version
    office 365

    updating formulas

    Hi,

    From the attachment, I am trying to find a way of being able to automatically update the master sheet with customer information from the customer 1 and 2 tabs.

    I have tried to use pivot tables and the get pivot function but the problem is when a new date with new information is added to the customers tabs the master sheet is not automatically updated with the most current information. Am I using grt pivot data incorrectly or is there another way?

    Any help would be great fully appreciated.
    Attached Files Attached Files

Posting Permissions

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