Recent content by DanAuber

It seems that Windows have discontinued Windows Movie Maker as of Jan 2017. I've deleted the version from my PC but now I want it back - does anyone know somewhere secure and free I can download it from ? Thanks ! Dan

Simple and Elegant - thanks !

Hi Skip - yes Boss ! Please see the attached which I hope allows you to respond. Regards Dan http://files.engineering.com/getfile.aspx?folder=ea594367-62fa-475a-a01a-88fbd0843f11&file=example.xlsx

I'm looking for a formula to find a max value and then return an associated field E.g. On sheet 1 I might have ABC1 in cell A1. I'd like a formula in Cell B1 that: Goes to Sheet 2 and looks at the data - e.g.: ABC1 11 Banana ABC1 15 Apple DEF3 32 Peach DEF3 18 Pineapple...

Hi there, I'm struggling to write an excel formula to do what I want to do. I have a list of Countries and each is supposed to have a unique rating in the list. I want to put a formula in to check this. In a perfect world the formula would come back with the number of unique records for the...

Flag that - working just as expected - thanks !

Thanks for this Skip - it doesn't seem to quite work - but it might be enough for me to play with your code Dan

Hi Skip, Sorry again. I'm not sure what kind of shape I'm working on or what the name of the instance is. I'm attaching an example of what I get out of BI. 1000 thanks for any help you can provide Dan...

Sorry Skip. Once I have the data in an Excel sheet, it is then linked to from a Word Document. In order to get the graphs to have borders looking OK I need the images nicely positioned in a single cell. - I have to link to the cells rather than the images because I'm using a link that I can...

Thanks for that Skip. This spreadsheet is created via a Business Objects export function and I don't have any control over how it starts out. My macro then steps in to tidy it up - I hope that explains why I have to do it this way. I tried running your script but got the error below. Am I doing...

Hi there, I'm trying (and failing) to write a script to take an image that is already in an Excel work sheet and put it into a single cell - preferably so there is a 1mm gap between the image and the borders of the cell. No idea how to write this code and can't locate much on the internet. It...

Hi there - just wondering - when using the irr function should I use inflated or uninflated values ? Or can you use either as long as you're clear what you've done ?

I have a very simple macro as follows: Sub Run_Cap_Rate_A() Range("AF8").GoalSeek Goal:=0, ChangingCell:=Range("C7") End Sub I want to change the code so that the Range("AF8") bit varies according to what is in cells in a sheet. In my sheet I have a column number in Cell A1 and a Row number...

Hi Gavona, Thanks for this - yup it's a good start - but the field mapping is somewhat a dark art involving the need for named ranges (with no help apparent on if named ranges should include headers, recommended naming etc). I found that it became a whole lot simpler if I saved my file as a CSV...

Hi, I want to import a series of calendar events from excel into outlook. I don't know how I define a format or how to do it. Can anyone help ? Thanks Dan