Search results

Hi Hui, I have placed the file in this link https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1?m I hope this works. The issue we are discussing is found on the first worksheet DB01 in cell N2. I look forward to your replies and inputs to the improvement. Regards Rob

Hi Luke, It provides a different reply, with three tabs "Settings", "Error Alert" and "Input message" I have tried to play around a bit here as well so as to change the range -to no avail. Regards Rob

Hi Luke, Thanks for the reply. I am not offered that opportunity to select on cell. When I select the shaded area which spans seven columns on one row the above result applies.

Hi Hui, Thank you for the reply. I select as requested and the first pop up appears with an option of three Y/N/Cancel The text that appears above: The selction contains some cells without validation settings. Do you want to extend data validation to these cells? I hope this helps

Hi Luke, I need to select it sorry. When I select it a little marker appears on the right hand side with a down arrow and I can then select the project listed therein. I cannot change the range to allow me to add additional projects. I do not know which of the three it may be that you...

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 Dan, Thats correct - if the data changes on the network then the table should also change as it reflects new data.

Hi Dan, I have a database that is populated through my website and it is thus on the network. Well thats the way I understand it to be

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 Magbo. Thanks for the link and the idea - it is the one that seems to work best. If you dont mind - please explain how the shading is added ? Regards Rob

Hi Luke, Thanks for the reply. The link doesnt work as you see it as the reply box will not allow [ ] brackets. I have thus tried to explain that you must put square brackets around the 1 and then it should work. I hope this helps Regards Rob

Hi Luke, Thanks for the reply. The graph I am trying to reproduce is found at this link http://www.cma.org.za/UploadedMedia/Book2[1].pdf Page 4 Fig.5 . . . Book2 (Open Square brackets)1(Close Square brackets).pdf . . . Regards Rob

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

Hi Folks, I have copied a work sheet (DB01) and given it another name (DB02. I have data in a worksheet called INPUTS. Whe I want to utilise the data from a cell in the INPUTS so that the data appears in the DB02 worksheet, I get the actual location rather than the value I request...

Hi Hui, Thanks for the help. the secrte is in selcting the labels on the left and draging , not just selecting the data in the rows without the labels. I appreciate the help Regards Rob

Hi Hui, I have three rows. Row heights are 5,12.75 and 5 respectively The values are 1, 10 and 1 in each cell. I copy the three cells form the three rows (33 to 35) as described and paste using "format" to row 37 to 39. The numbers are not copied and the height of rows remain...

Thanks Hui, Not succesful - I am using excel 2007 Regards Rob

Hi Hui, Thanks for the reply. Not sure what you mean though by the 21:40 to 21:100 and time the selection ? Regards Rob

Hi Folks, I have started a dashboard and the column widths and row heights have been set for the first 6 reports. I do however wish to copy all six reports downwards until I have twenty reports and in so doing keep the row heights and column widths. Please advise which is the easiest way...

Hi Folks, Pretty new at the excel stuff. Can someone tell me what the diference is between these diferent references: C3 C$3 $C$3 Regards Rob

Hi Hui, Thanks yes I have and that does work. I was wondering if there was a an overide and thgus should the value change then the label would always then appear say 10 or 15 units above what it currently is and thus not clas with the column itself. Regards Rob

Hi Folks, I have copied the waterfall chart as provided and maniupulated the data to suit my requirments. I would howver like to have the labels appear higher than can be veiwed using the excel default. Is it possible to do this or am I stuck with the three defaults offered by excel ...

Hi Folks, I am wondering the following. If I have inserted a shape of colour red, can I get the colour to change if data automatically satisfy certain cirteria to say blue. Regards rob

Hi Hui, Thanks for the prompt replies and assistance - much appreciated. Regards Rob

Hi Hui, I have posted the file at this link https://spreadsheets.google.com/spreadsheet/ccc?key=0Ahe_P6TwosJTdEF1YTZ4MS1pV0NDbGV4eE8xQmozWlE&hl=en_US&authkey=CInJo-8I My first objective is to increase the text size in the list box to be nearly similar to that seen adjacent to it. The list...