Search results for query: *

Hi - I am doing an email mailmerge in MS Word and whilst the font is all the same in the Word document the hyperlinks change from Verdana 9 to Times New Roman 9 in the version sent by Outlook. This looks a bit rubbish. Can anyone advise what I need to do...? Thanks! Rachel

Thanks for the advice - I have reposted it.

I have added labels to a scatter chart using the below macro but would also like to add leader lines. I am not very familiar with VBA and borrowed the code for adding the labels. Can someone please advise how to add leader lines also? Sub AttachLabelsToPoints() 'Dimension variables. Dim...

I have added labels to a scatter chart using the below macro but would also like to add leader lines. I am not very familiar with VBA and borrowed the code for adding the labels. I would appreciate it if someone could let me know how to amend this code to add in leader lines also. Sub...

Thanks guys - it worked when I pressed F2 and then enter... I will try the macro too... Regards Rachel

Hi - I am updating a workbook sent to me by someone else and the formulas I enter do not calculate but appear as text. It doesn't help if I change FORMAT CELLS from Text. I have checked TOOLS, OPTIONS, CALCULATION and that is set to automatic so I am at a bit of a loss as to why it won't...

Thank you so much....! That worked beautifully!! I do apologise for steering you both in the wrong direction earlier on. I think I confused myself!!! It should be against the law that both of you are so clever...! :) Rgds RachieD

Hi Geoff - thanks for your comments. This is what I am trying to do... Column A is populated by text. I want to categorise the entries into the following: INSIDE, OUTSIDE, PIPELINE. I want the formula to say: if it says Commit then it is INSIDE, if it says Inside then it's INSIDE, if it...

Thank you very much Geoff, that worked brilliantly!! Is it possible to use this in a nested IF statement too? I tried but got the message saying I'd used too many arguments... Thanks again!! RachieD

Hi Geoff - yes I did look in the help file before I posted the question and when I received the answer from Combo, but I am still not sure how to do it.... Any help on this would really be appreciated... Rgds RachieD

Thanks for your response Combo - however, I'm afraid to say I have no idea how to write this... could you please give me an example? Thanks a million!! RachieD

Hi - is it possible to use Wildcards in an If statement? For example, I want to say something like: if A2 contains "Commit" then it is an "Inside" deal; else it is a "Pipeline" deal but if I write the following =IF(A2="*COMMIT*","INSIDE","PIPELINE") and A2 looks like this: A2 this is a...

Perfect - thanks a million Glenn!! I've given you a star! Cheers RachieD

Hi - can you please advise how I can amend my formula to replace my vlookup #N/A errors with 0. Formula is =VLOOKUP(A7,ProductPivot!$A$3:$B$500,2,FALSE) I need to sum the results. TIA RachieD

Thanks very much everyone - your help was invaluable...!! Both xlbo and skipvought came up with the answer I needed - Skip it was calculated relative to FY05. Thanks again!! Cheers RachieD

Hi - I am working out the year-on-year increase/decrease in a set of figures and I am a bit stupid!! The following calculation is giving me a problem because it involves a negative: A1 B1 C1 Actual FY05 Actual FY06 =b1/a1*100 -7,192...

Hi Column E in my spreadsheet allows the user to select the currencies "GBP" or "Euro" via a data validation list. The monetary values are entered into columns F - L. As Conditional Formating will not do it, I would like to write an "IF" Statement so that if they select Euro, the format in...

Thanks Tony - it worked!! I appreciate your help. RachieD

Hi I used the following FAQ707-1657 to set up a date stamp in Excel when data is entered, this worked fine. Does anyone know how I can record the time too? At present the date is correct but the time shows as 00:00. I amended the above FAQ with the .NumberFormat below, but it made no...

Hi - I want to create a "search" on a new form / switchboard to bring up only the form records relating to a specific client without using the filter option. The form I want users to retrieve is called frmDealDetails and the information I want them to search on is called [client]...