Last seen: Apr 28, 2025
@Mrm Not sure either what your intentions are but if you want the slicer to control both pivot table based on the 'Resource', then you must use the ...
Can you share your file? It's difficult to help based and your description of the problem only.
Oh, but then you should your approach. No need for the intermediate EXTRACT table, provided you are using a modern Excel version, using CHOOSECOLS and...
What do you have in mind? Change something in the EXTRACT table or add a row with relevant data and the scrollable view updates automatically. Am I mi...
Not 100% what you asked for but it could be acceptable for you anyway. The following M-code produces a table that resembles your FINAL sheet. Just poi...
Change the CHOOSE part of the formula to CHOOSE(OrderBy,1,-1) and it shall work.
Please share your file (press the paper clip icon "Attach Files" below the editor where you write your reply) as it's not clear from your question alo...
Still not clear to me. Sorry! Do you really set limits up to 56 hours on a weekly running total basis. For instance, employee 1 worked 2102 hours in 2...
It seems that when an employee works, for example, three full weeks of 40 hours for a total of 120, they only get 3 hours leave. Even though 120 equal...
@j8150outlook-com Sure, that's an option as well.
Well, since you prefer not to work with VBA and if you are on a modern Excel version that supports the FILTER function, you could extend the file with...
@j8150outlook-com Thanks for the file, but I don't understand what I'm looking at or how you want to split it.
Difficult to help if you don't show us how your file looks like and explain the logic for splitting the file. Please attach your file.
Checked on my end. Same set-up as Alan. Everything still works for me. That is, STOCKHISTORY and Data Types.
@cal Have you considered/tried Power Query?