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 Grah, Thanks for your reply. The problem I had was that the ranges in the x axis were different. I have solved the problem.

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 Belleke, Thank you for your reply. IT is not quite what I was looking for. I have have attached a picture that might help. In providing a description - if I select the SANS icon a drop down list appears of pdf documents I have on my computer. In this case if I select 1200 C a user form...

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

p45cal, Thanks very much. This works like a dream. Without asking to much, what was I doing wrong that the number was not reading correctly?

Thanks Pavan.I will give it a look.

I have checked the option of copying the number to another cell as suggested. If I copy and paste the result is 0.000. If I copy and paste values the result is 118.1158 If I copy paste using formula the result is also 0.000 The result I would like to see is 118.1158 rounded to the third...

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 Vletm, I have looked at the values. The values in the varies worksheets all are a result of a formula (Pythagoras) and the results of this formula have values that do not only end with .000 but with other variations. It is these exact values I wish to appear in my "Sheet4". It may be that...

Ok so now I have worked on this excercise, my challenges are as follows: The value that have been garnered from the various worksheets, does not display the decimal value and they are rounded off to reflect as 4.000 for example instead of 4.235. My work so far Dim erow, MyValue As Long For...

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

I am trying to roll the data into months

Thanks for the reply. I understand. I like the idea of using week numbers and that being the case then surely that can be then allocated to months -or is my thinking the illogical?

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 Asheesh, Thank you for the reply -my apologies for responding somewhat late. The submittal information is currently found in columns BL & BK by a date appearing for the day the submittal took place. It is possible that a submittal was received and returned in the same week and on the same...

Hi Asheesh, Thanks for the reply. The logic you provide is correct. And based on the selection made in the LOG worksheet "Column AO" will impact the result shown in columns BL, BK,BM of the same worksheet. What seems to be happening is that the item 153 should be found in both column BL and...

Thanks for the countif function - I will try that

Hi Asheesh, Thanks for the reply. I have looked at the value in the LOG worksheet specifically AO156. That function doesn't change the formula or fix the error being encountered.

Hi Faseeh, IT is noticed when I am working on the REPORT page, I have not been able to pin point the cause yet.

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

Thanks for the reply - It is a challenge this end - so I am not sure. All the numbers show normally like you have shown and then while I am working it reverts to #N/A as explained. Thanks for looking at it for me.