Search results

Hi Folks, I have created a ribbon that looks like the attached image. However when I want to add macros, I select "customise ribbon" I do not see the name of the ribbon appearing in the list. How do I set about the process of getting the TAB"Epoch" included, so that I may assign my macors?

Hi Folks, I have created an S-Curve (chart) with date on the X-axis and percentages on the Y-axis. I have inserted a vertical line using and error bar, to represent todays date and it is marked as a secondary axis. The challenge that I have, is that when doing so the range changes on the...

Hi Folks, I am developing a custom ribbon and require some assistance. When I hover over an icon in the ribbon the supertip will reveal what the buttton will do if selected. If I select the button in the ribbon I wish for it to open a pdf in a userform, with scrollable bars, thus allowing me...

Hi Folks, I am trying to create a progress report which shows charts and some text. The spreadsheet has over 200 worksheets and numbered in multiples of 20, ie 20,40,60,80,100,120,140,etc. The idea is to fetch the charts selectively from 40-100 and have them show in a report. I am not sure...

Hi folks, I have several macro's which I would like to include into a ribbon icon, to make executing the macro easier. I would be appreciative of any info.

Hi Folks, I have a scatter chart with serveral lines included. I wish to shade between some of the lines and looking for a way on how to do this. Any help here would be welcome

Hi Folks, I have a workbook with over 300 pages. the pages however have data in a common cell which I would like to extract, into a single list. thats the first challenge. The second is to inquire whether this list would be dynamic, as it is possible that the data in the individual...

Hi Folks, I have a chart where I have managed to get the month and year to show on the axis, however I get repeates of month (i.e. May.May May) and the year appears below each month rather than show as 2014 and 2015 and soon 2016. I am also trying to get the month to read between the monthly...

Hi Folks, I have been working on a file which contains the ARRAY function and whilst it works initially - it does not seem to continue through to its end and thus it does not provide all the values required. I have attached the file and more detail in the REPORT page. I have also tried to use...

Hi Folks, I am working in a work sheet which uses the formulae CONCATENATE. The formulae works and presents the correct value required however as I continue to work with the worksheet, the value changes to #N/A and this impacts others cells in the work sheet. What could be the reason for...

Hi Folks, I hope you can assist. I have two spreadsheets (MSR07112015 & Report). My data rest in the first and I wish to create a "dynamic" table in the Report, that is when the data changes in the first spreadsheet, the reported data will change. I have tried using the INDEX function and get...

Hi Folks, I am having a problem with the concatenateif function. I have highlighted the problem in red fill in the DTS worksheet. The idea is that upon obtaining a value in a column the number reflected in column b of the LOG worksheet must be listed. The problem is that the number of time...

Hi folks, I have a spread sheet that entries numbered 1-500, in column A, I have numbers in another column that relate to list the days outstanding. I have used a formula to count the number of times the days are outstanding between 1 & 10, between 11 & 20 and between 21 & 30, continuing until...

Hi Folks, My plan is to take data from various cells in a worksheet and transfer it to a different workbook and present this data in rows. I have tried to do this in the following macro Sub Macro2() ' ' Macro2 Macro ' ' Dim itemProjectName As String Dim itemScopeofWork As String Dim...

Hi Folks, I have a standard excel sheet which allows team members to enter data from several sites. My challenge is the consoildation of this data to a single worksheet in sequential rows. Is there perhaps someone out there that can provide advice / example? Regards Rob

Hi guys, I am working between two version of excel (2007 at the office) and 2010 at home. I have a worksheet which works with active boxes but when I change the print page or hide a column the active boxes do not stay where they are surposed to. How do I control that ? Regards Rob

Hi folks, I have a spreadsheet that has a column with values 1 or 0 and I would like to create a command button that if selected, all the rows in the column F - having a vaule of one (1) would then be hidden. Similarly if the show button is selected all the rows would then be visible again...

Hi Folks, I would like to write a report by using data already captured. As the rows vary I would like only the rows that have a certain value in a cell in the row to print - i hope that makes sense. If I have a value of 1 in Cell F6 then the row from A6 to F6 will be printed and on the...

Hi Guys, I am working on a rather complex dashboard and require some assitance. I the dynamic charts posted on the Chandoo.org site there is a fille offered for downloading called ChartDate Range2007.xlsx. This is the closest I can get to the desired effects I require. My objective is to...

Hi folks, I have two sets of data PLANNED and ACTUAL. I would like to plot the data on the same bar chart where the actual shows in red over the plaaned shown in blue. The periods relate to time and thus the actual could over lap the planned or in fact start ealrier than planned and thus a...

Hi Folks, I would like to know if it possible to have conditional formating on a bar chart ? I have developed a bar chart that has a pass requirement of 95%. If the implementation of the process achieves the pass requirement of 95% and greater the bar remains the colour it is. If however...

Hi guys, I am trying to find an excel spreadsheet that when I enter data it will produce an S curve ? Any help here would be most appreciated ? Regards Rob

Hi folks, I have a drop down box copied from a spreadsheet which will read data from a page in the workbook but it wont allow me to change the range. It doesnt seem to be the normal drop box as ti one allow me to change the text colour and border colour and the drop down arrow only appears...

Hi Folks, I was wondering if someone could help with the following: I have a link www.gnjgf.co.za/dsoneuk40.php which takes data from MySQL to create two bits of data. Whilst the data is not quite represented correctly - I would like to do a similar excercise using VBA - where the data is...

Hi Folks, I have a graph that is using known data. I would like to create an envelope that when veiwed with the line graph the criteria can be seen as met or not met. That is should the line pass over or into the shape then the criteria are met. I have looked at some example on the...