View Full Version : VBA help for sales report
mimixue
09-29-2020, 07:25 PM
Hi,
I'm new and unsure if anyone can help.. im using excel for mac...doing a sales report & figuring out how to lock & auto update all the pivot tables inside the 3 red tabs when data is pasted in the green tab 'paste data here'... tried to upload the file here but unable to...
i had uploaded my file to here - https://mega.nz/file/w8lVTKrA#zxnCJww-5f0lGWWAwFHlojzWOkDA0z3hDEGHB4xQ0XQ
Bob Phillips
09-30-2020, 03:10 AM
Upload the file here. I am not going to create an account on that site just to see your file.
mimixue
09-30-2020, 03:15 AM
?¿? it does not require any login to download.. i'll try to upload then
mimixue
09-30-2020, 03:26 AM
it just doesn't allow me to upload my document... 27238
Paul_Hossler
09-30-2020, 07:28 AM
File is 3.1 MB -- I believe max size here to attach a file is only 1 MB
In the code sheet for "Paste Data Here" try something like this
Option Explicit
Private Sub Worksheet_Deactivate()
Worksheets("Sales").PivotTables(1).PivotCache.Refresh
Worksheets("Sell Through").PivotTables(1).PivotCache.Refresh
Worksheets("Staff").PivotTables(1).PivotCache.Refresh
End Sub
mimixue
09-30-2020, 07:36 AM
Hi Paul, Thanks for the info.. at least your reply seem kinder.. no worries, I will get help elsewhere.. appreciate..
mimixue
09-30-2020, 08:08 AM
Hi Paul, my apologies... just realised that you replied to my question.. I missed the second paragraph just now.. my bad if I sounded rude.. I will try your advise later.. thank you.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.