Recent content by ashtonp2

Thanks Ken you are a star. I did look at microsoft as well but could not find that article Thanks so much Paul

Hi John Thanks for the tip. The spreadsheet does reference to another spreadsheet the person does not have access to as it is on my c drive. However I have other spreadsheets where this is the case and so long as the person clicks on do not update links they can still see the values in the...

Hi I was wondering if any one can help me. I have a spreadsheet which has links to another spreadsheet, they are a simple = the value of the cell in the other spreadsheet. I can open the spreadsheet okay on my machine. When I send it to my colleagues it opens with the message do you want to...

Hi Sorry did not make it very clear. I would like it to arrive as appointment so people can use the accept or decline options and not arrive as an e-mail message. Again it does arrive as appointment if I type the e-mail address and arrives as an e-mail message if I select the address from my...

Hi I am using Outlook 2003. I am having trouble when I put an appointment in my calendar and send it to other people via the internet. If I type a persons e-mail address it arrives to them as appointment, however I select the persons e-mail address from my contacts it arrives as an e-mail...

Hi the formula is =CONCATENATE(IF('Look up tables'!$AI$3="all","All",H4),IF('Look up tables'!$AI$5="all","All",I4),IF('Look up tables'!$AI$6="all","All",G4),IF('Look up tables'!$AI$7="all","All",E4),IF('Look up tables'!$AI$8="all","All",F4),CONCATENATE(C4,D4,B4),IF('Look up...

Hi Can anyone help me. I have created some formulas in Excel which need to be on approx 9,000 rows. Someone told me if i named the formulas the spreadsheet would be smaller and work faster. I have the original formula on the top row and then copied it to the paste board, gone to the insert...

Hi I am a very experience user of access (but learning). I have a table of information and would like to create a new field in the table which combines 2 other fields. I want to do this in the table and not as a query. Can this be done and how do I do it Thanks Paul PS I am using access 2002

Hi I have word 2002, when I go to save a document the save as function is greyed out and I can not use it. This happened to me the other day and after re booting the maching it was okay. The problem has come back but afer re booting several times, I still can not use save as. Does anyone have...

Thanks Eddie for the tip, the only problem is I receive the data from another source in this way and will not be able to get the input option changed. Any other tips ;-)

I have a column of date with a date an order was created. I want to creat a new column which just shows the month and year that the order was created. Does anyone know how I can do this. For example order created 23/05/04 would like to see in new field as 05/2004 or 01/05/2004 I am sure...

I am using the sumif formulat in a speadsheet I am creating and wanted to know if there is a way in the sum range I can ask excel to conconcatenate certain columns to create my sum range. I realise I could create the conconatenate formula in another column and then point the sumif funtion to...

Thanks Ken. I thought that I would only be able to do it using VBA.

Hi I have a table of data which has formulas to calcute the restuls based on options which people select from a drop down box. Depending on what they select some of the rows may return blank figures. Is there anyway I can automatically tell excel to hide a row if a particular cell is equal is...

Thanks Skip and Jim both formulas worked great. Again thanks this really helped Paul