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...

Brilliant. Its working now The final bit of the puzzle is that i am creating a pivot table on the fly for each of the two worksheets in each file. There are some managers where there is only data for one of the worksheets which means that the pivot table for that worksheet is blank. I get an...

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...

Thank you so much. Worked like a dream and given me exactly what I am looking for

Oops that was a typo. They are two separate worksheets within a master workbook that I’m then querying to get the reports for each manager. Not really sure how to get it so that the filtered data from the two worksheets end up in a single workbook which will have the managers name in the file name

...1) <> "\" Then fPath = fPath & "\" For i = LBound(nmAry) To UBound(nmAry) Set Nwb = Workbooks.Add fName = Dir(fPath & "*.xl*") Do If InStr(fName, "_") <> 0 Then If Left(fName, InStr(fName, "_") - 1) = nmAry(i) Then...

I got it figured out. Went back to basics and set the status column to webdings font, in each cell I set the symbol to a black circle then used conditional formatting to change the colour of the circle. Much easier and worked like a dream

Hi Skip I am using conditional formatting in a hidden cell and then a linked picture in another column linked to cell with the conditional formatting (which contains a vlookup)

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 have sorted it I have protected the worksheets whilst allowing the user to change the size of the rows. That way they can alter them as needed without destroying the formulas

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...

It would only be one specific course. I would only need to track their clock number name, invite name and the date the invite was sent.I don’t need to track completions (that info is available from within the course software itself)just the invites issued.

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 DM I meant to close down the workbook having displayed. Message telling them that they have reached the max number of tries and need to book onto a classroom course

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...

I have attached my workbook The Named Ranges are the pictures on the quiz sheet. I have renamed the sheets to make more sensehttps://files.engineering.com/getfile.aspx?folder=532f30a2-2065-40c7-b21a-54f3e4d92179&file=multi-choice_template.xls