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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
?¿? it does not require any login to download.. i'll try to upload then
it just doesn't allow me to upload my document... Screenshot 2020-09-30 at 6.24.46 PM.jpg
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
Last edited by Paul_Hossler; 09-30-2020 at 07:42 AM.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
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.
Reply With Quote
