Search results for query: *

Hi All I am trying to create a booking tool in excel for booking hot desks I have got a grid with time slots down the left hand side and dates along the top row There is then another grid underneath where the people book the hot desk by selecting the date, time slot, name, desk number etc. I...

I have got a workbook which has been in use for a number of years now Within the main spreadsheet in the workbook are a few "helper" columns which are hidden from view for end users. I have got another sheet within the workbook which contains pivot tables based on the data in the main sheet...

Hi There I have got a list of managers in my spreadsheet. I am trying to cycle through the range and load each manager into a specific cell which I am then using as the basis to run a series of macros (filtering the data in two sheets, copying the data into another workbook, creating pivot...

I am trying to create individual workbooks for each manager from a master workbook. Each workbook will contain 3 pivot tables on a single sheet. I am using the following code. My problem is that the pivot table just gets copied and pasted in as values. Ideally I want the actual pivot table...

Hi There I have created two reports for each manager. They come from separate systems so are in separate workbooks. All the Reports are in the same folder. They are listed by Manager Name. So for example in the folder I have got a report PersonA_InspectionStatus and a report...

Hi There I am trying to develop a report whereby I filter a master report by manager and send the filtered report to each manager with their data. This worked fine until this morning when i added a traffic light system with pictures for the red, amber and green status. Now when I run the...

I am experiencing a really tricky problem and I am hoping I can explain it in a way that makes sense. We have recently been upgraded to Office 2016 at work. I am creating a workbook that is going to be shared with many different people. I have spent days formatting the workbook so that it is...

Hi All I have a spreadsheet on which I am collecting monthly submissions on compliance with various company KPI's. We have it set up so that the spreadsheets for each site are contained in different tabs within a single workbook. When the user opens the spreadsheet I want them to be able to...

Hi there I am trying to set up a system whereby I issue email invites for a e-learning training course to a list of recipients. I am comfortable with using mail merge. What I would like to ideally is each time, the mail merge is triggered, keep a running total of how many times each recipient...

Hi There I have created a spreadsheet with a project task list. The task list has start dates, end dates and project status. I now tried to create a gantt chart which i wanted to conditional format to At Risk, On Target, Overdue etc. However, all the options for formatting including...

Hi There As Part of a work project, I have designed a quiz in excel. The quiz contains a question set from which a set of 10 random questions are selected and loaded into the template each time the quiz is taken. When the employee starts the quiz, they input their clock number and associated...

Hi All I am working on developing a quiz in excel for our workforce. The quiz consists of around 80 possible questions with associated multiple choice answers. Each time the quiz is taken a different set of 10 questions will be chosen. A few of those questions have associated signs. The...

Hi All For the past few months I have been building a dashboard at work using excel. Until now the dashboard consisted of a couple of sheets of graphs/charts etc which were based on pivot tables within the workbook. The underlying data was also on the workbook. All was working fine until I...

Hi there I am after some help We have a model at work which has 13 different objectives. I am trying to devise a spreadsheet linked to our document portal whereby the 13 objectives are listed on the spreadsheet in individual cells. There is then a drop down box next to each objective which will...

HI There I am working on a Dashboard which will report on a number of KPI's. I have already created a variety of graphs which I created in 3D format. I am now adding in some Gauge Charts. For consistency, I would like to make these charts 3D. Is this possible. I cant work out how to do it.

Hi There I am developing a KPI Dashboard for work. I am trying to make it versatile so that individual users can customise it to suit their own requirements. I have added a multiselect listbox with our weeknumbers 1-52. I want the default values to be the current week of the year plus the...

Hi There I have a spreadsheet which brings together various totals from some underlying spreadsheets. Initially I had used countifs to display the totals on the summary spreadsheet. However, following a meeting with a couple of other colleagues this morning I need to change my approach. The...

Hi there. Not been in here for a while but once again it’s time to pick the brains of some of you tek-tip experts I have been working with a colleague to produce some weekly statistics on closure of actions from some of our systems. I have pulled together a workbook with several different...

Hi there I am attempting to create a "report dashboard" to pull together a series of reports. The ultimate aim is that users can select a series of criteria using multiselect listboxes on a userform. When the items are selected in the listbox, they are dumped in a worksheet which is then used...

Hi There I wonder if someone can point me in the right direction as Ive been looking since yesterday but cant find the right code to meet my needs. I have got a spreadsheet with 5 listboxes. They are set up as multiselect listboxes so that if desired users can select more than one item from...