Search results

Fantastic.......as always. thanks

Good afternoon all, Small problem. I currently have a colum of 275 mobile numbers, all with the 0 taken from the begining. I need to populate all the numbers with +44 at the begining. Is there a fast way of doing this? Thanks in advance for any help!

Hui, Once more..........Thanks a Million!

Good afternoon. I have created a scrolling table which has data in the date order. Now I have linked a bar chart to the table to display the data in a simple visual way, the problem I have is the following. The dates in the data are not consistent, for example I have, 10/08/10 11/08/10...

Hui......I DID IT......Praise the lord. Another little problem (nothing major) I am currently linking a line graph from my KPI Scroll Table which includes dates, however the dates are not continuous. In the selct data for the table I have Selected from B5,B9 thats fine and the chart scrolls...

Thanks for your help!

Hui, Is it possible I can send you what I have got so you can show me where I have gone wrong? I am just getting myself frustrated, I have been trying this for 2 days, how embarrasing. Thanks

Hui Thanks for your speedy response, it is really apreciated. My data is on sheet 2 (all in the same workbook) I have just tried the following formula =OFFSET(Data! Then I click on cell E5 in my data sheet....so far so good. I then continue the formula with Calculation part, now what is...

Hello all. Now I admit I am not the greatest on Excel but I am trying to learn new things every day. I have stumbled upon the 6 part KPI dashboard and I am already stuck on the first part which is making a scrolling chart. I have my date in sheet 1, as instructed I then make a 10 row table...

Good afternoon all, I am fairly new to Excel 07 and picking bits up as I go. This site is helping loads. I have a workbook with over 40 worksheets on it. I have protected the workbook so when advisors open it they have read only accsess ( only I have the password) I have added more tabs to...