Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ashtonp2

    Excel #REF

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

    Excel #REF

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

    Excel #REF

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

    Outlook 2003 Calendar

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

    Outlook 2003 Calendar

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

    Naming Fromulas in Excel

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

    Naming Fromulas in Excel

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

    New Field

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

    Save as in word

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

    Date

    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 ;-)
  11. ashtonp2

    Date

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

    sumif

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

    Hiding blank rows in Excel

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

    Hiding blank rows in Excel

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

    Excel

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

    Excel

    Hi The formula I started to write is =IF('Lookup tables'!$C$51=1,T2,IF('Lookup tables'!$C$51=2,U2,IF('Lookup tables'!$C$51=3,V2,IF('Lookup tables'!$C$51=4,W2,IF('Lookup tables'!$C$51=5,X2,IF('Lookup tables'!$C$51=6,Y2,IF('Lookup tables'!$C$51=7,Z2,IF('Lookup tables'!$C$51=8,AA2,0)))))))) I...
  17. ashtonp2

    Excel

    Ps I should have said I have tired to do this with an if statement but the problem is that I actully need to do this for 12 columns and the formula is too long with 12 if statments
  18. ashtonp2

    Excel

    Hi Can anyone advise me how I can write a formula which makes a cell equal to a1 if the contents of another cell A1 in another sheet equals 1 and b2 if the contents of the same cell equals 2. I need to be able to drag the formula down so on the next row the formula then equals a3 or b3 etc...
  19. ashtonp2

    Pivot tables

    Hi I recently upgraded to access 2002 from access 97 I am not an advanced user but slowly learning. I have 2 problems 1) In access 97 I had created some forms using pivot tables which used Excel to analyse the data. This was all automated and allowed me to create charts in excel...
  20. ashtonp2

    Rounding up

    Thanks This worked perfectly

Part and Inventory Search

Back
Top