happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
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.
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.