Search results for query: *

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

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

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

In Excel, I have a column several thousand rows long with notes on some of the cells. I want to create another column next to this column which bring the text from the notes into the cells (so I can then quickly isolate all the cells with notes and sort by them). Does anyone have a macro/way to...

Hi there, I want to run some code that picks up whatever is in Cell A1 on sheet1 and then uses this as the File Property: Category. If I do this while running a record macro it doesn't write the code. Can anyone help ? Thanks Dan

I have a spreadsheet with pathnames in Column A, filenames in Column B and a datafield in Column C In Column D I want to write a Sumif Statement as follows: =SUMIF(Pathname/Filename/Sheet1$B$Y,datafield,Pathname/Filename/Sheet1$Y$Y) but I want to use the data in the other columns so it would...

Hi, not sure if this is the right thread to ask this. I have about 1000 files in a directory and I want to globally rename them to Artist Name <space> TitleName.mp3. (They have the Artist and Title stored against them). Does anyone know how I can do this ? I'm thinking possibly by running a...

I have a column of cells which also are worksheet names. Thus: Water Roading Stormwater etc... I want to put a formula into the adjacent column to sum the column K in each case in the relevant sheet - but I don't know how to reference the worksheet in the formula. For example, if the word...

I want to put some code in an Excel macro to select all rows from a certain point downwards. The last row of my code so far is: Range("C" & NumberofPGRows + 1).Select This takes me to the first row I want to choose. I then want to choose all rows below (including the one I am on) right to the...

Hi there, in Excel if I'm in a cell which is adjacent to a column with data in it, if I hover the mouse over the bottom right corner (so I get a black cross) and double-click - the cell I'm in copies its formula down until it gets to the end of data in the column adjacent. Is there a way to...

I want to write some VB code that so every time I load a certain form (so this code would be in the On Load event of the Form) - the page setup is switched to Landscape and the left and right margins are reduced to 20 mm. Can anyone help me with this code ? - Hoping this is a very simple request...

Hi there, I have a HUGE sql statement which I'm entering into a Module as follows: docmd.runsql ("Select etc etc etc;") The statement will not fit on one line so I'm trying to do the following: docmd.runsql ("Select etc etc _ etc etc etc;") However Access will not accept it Can anyone...

Hi there - I'm getting an 'Operation must use and updateable query' error but I have no idea why. Here is my code: UPDATE new_DC2000 SET new_DC2000.Datefield = (SELECT BNZ2002_Date.expr1 FROM BNZ2002_Date;); The select part works on its own and returns one record - both the select field and...

Hi, I have a button on Form1 - when it is clicked I want the following to happen: i) Open Form2 ii) Close Form1 (or the other way round) Can anyone help me with this - I have tried the below, but Form1 stays open grrrr... Private Sub Command5_Click() DoCmd.OpenForm "Form2" DoCmd.Close...

I'm importing data from a flat-file - There are several million records in the file - but I only want to import those where the first field is '2001' - is there anyway to do this using the import/transfer text routine ? I know I could bring all the records in and then delete the one's I don't...

I'm trying to enter 16 digit numbers into Excel. There seems to be a bug here: Try this - i)open a new workbook and goto cell A1 ii) Enter Number:7845907834568970 iii) Format the cell to Custom 0000000000000000 (16 zeros) iv) Now change the 0 at the end of your number to a 9 - Excel changes it...