Search results

yes it looks my office 365 is not working correctly as I said sent it to a mate who should be on same version but his is updated and works , it seems to work on my Mac office so will finish there and see what happens thanks again

found this in my files as cleaning out my old laptop we used to use this previously and it was great looks like Google have changed some map items and the map is now not good but it was a great way to do lots of post codes so if anyone has a work around would be good to know

found this in my files as cleaning out my old laptop we used to use this previously and it was great looks like Google have changed some map items and the map is now not good but it was a great way to do lots of post codes so if anyone has a work around would be good to know

Hi Peter thanks for this , it seems when I put all the cells from Z just so #value am I doing something wrong

I have created a time sheet to help me in my position, however I have been asked to do the following Seven day operation Done this lol Monthly contractual costs calculated Overtime rate to be driven by employee/contract type Sick Pay calc based on contract type Agency costs to be able...

perfect trying to play with it to see if I can get all the graphs working myself - a test lol thanks you so much

the attached is a sample file one of my colleagues has done but wont help me I think he is after brownie points I want to be able show the graph without the drop of as shown her as you put the data into the month the sheet refreshes and updates no drop off just trying to make it look good and...

I am trying to do pivot tables with out any success I have attached the sheet I am trying to use and it needs to be easy for to complete month on month, all the variations of pivot look awful may data in wrong format , I need to do line graphs for each building and show the month I have done it...

Guys what can I say amazing and learnt so much in a short time many thanks for all your help

looks like I am working through it wow thanks how do I get rid of the word charity on my version they want there name there

think I sorted it once I understood what you had done been a great help just need to make text bigger now but thanks

thanks your a star

Hi this is great there seems an issue with Sept onwards but this is brill can the drop down text be bigger hope fully you can help ,, your a star

Hi guys any advice I have a sheet with 12 months tabs that I want to feed into one sheet but only showing the month from a 2floating2 drop down sheet I have created the from dash board and linked in the sept 18 sheet (this is what needs to be completed on a Daily monthly basis) what is the best...

many thanks

thanks

Hi guys been working on it during lunch , trying pivots but I was loosing data so I created another pivot still same spoke to a friend who said pivots will only ever show data that is there, hence why you keep on loosing data He suggested use layout 1 and then use multiple sumifs rather than...

Morning All many thanks for the advice I sat with the boss and went through this and apart from just taking the information from the sheet we complete for the inspection , I really struggled to understand how simplifying the information to give any other view. I sat with him and pulled together...

Dear all I have looked through most of the great work you have created on here but still stuff with inspiration or direction on how to show information in a dashboard that is high level yet means something when you look at it so here is what I have I have a file with 12 separated tabs for each...

thanks for this now done this so now I have the following top row site names starting column 3 column 1 month Column 2 kpi and the score dragged in from each sheet need to sit down and see what looks good , struggling with that , may need to take a breaks lol

Morning Guys just learning to do things and I have seen some amazing complicated Dashboards on here I have a KPI document to capture month by month information for a number of sites I want to be able to display a dashboard that tell the story month by month but by site and by kpi , I have...