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

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

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

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

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

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

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