VBA help for sales report

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#zxnCJw...z3hDEGHB4xQ0XQ

Upload the file here. I am not going to create an account on that site just to see your file.

?¿? it does not require any login to download.. i'll try to upload then

it just doesn't allow me to upload my document... Attachment 27238

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

Code:

---

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

---

Hi Paul, Thanks for the info.. at least your reply seem kinder.. no worries, I will get help elsewhere.. appreciate..

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.