Thank you so much Chihiro! I worked through the example link you sent to just understand the process which was really useful and then applied this to my main file as you described and it works great (after a few head scratching moments!).
Really appreciate your time and assistance in this and...
Thank you! I have Excel 2013.
In the attached file i have stripped a lot of my original data so and left just a few fields as an example.
Tab 'Data' is my existing employees
Tab 'Leavers' is my second data set of employees who left
Tab 'HC Pivot' is where i have created the pivots that I want...
Thank you Chihiro. My Excel knowledge is good but i am not advanced and my VBA knowledge is very minimal so you may need to explain this to me.
I'm not sure if the two sets of data can be related. They are based on employees - one set of data shows all the data for active employees and the...
Thank you for the links above xlstime. However, they address how to connect the slicers to multiple pivot tables when the pivots are all based on the same data set.
What i have is pivot tables that are based on two separate sets of data. Both sets of data have some common fields like Country...
Hi,
I have been using pivot table slicers for a large set of data for active employees and everything works fine. I now have another set of data for employees who have left in another tab and have a pivot table based on this set of data. On my dashboard I am trying to show a summary of active...
Hi Chihiro. Thank you for the update but I am still struggling - mainly because I am not very familiar with VBA! I have attached a portion of the file I am working on which has the 6 charts that I want to have the same set axis. The changes are made via Pivot Slicers in the 'Summary' tab...
Hello Chihiro. Thank you for your reply and apologies for the late reply as I have been away from work for the last 2 weeks. I have tried to go through this and enter the VBA code but it does not seem to be working for some reason?
In a tab named 'Summary' I have 6 different charts side by...
I have data in my file from which I produce a chart. Depending on the selection the user chooses from the drop down box, the data will change. I have a few charts based of this same data and I want the axis numbers to remain at the same levels.
In the data, I work out the MAX value I want on...
Hi,
With the help of this site, i have figured out how to do drop down lists in data validation where the options that appear in my second drop down list are dependent on the choice made in the first list.
However, i need to do this on an ActiveX Combo Box. I have a list of countries and the...
Thank you both for the formulas. The Index formula worked for most of the rows but some came back with error for some reason and i couldn't see why. The Lookup formula also worked - thank you!
Hi,
This seems straight forward but i am struggling to find a formula for this. I have data in rows and not all of the cells have data in them. For each row, i want to look up the range (i.e. A4:F4) and return the value from the last non-blank cell.
Could anyone please help?