VBA help for sales report

[mimixue]

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]

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

[mimixue]

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

[mimixue]

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

[Paul_Hossler]

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]

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

[mimixue]

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.