Search results

Hi, I'm trying to find a way of doing a vlookup (or other formula) that will return the format of a matching cell rather than the value. Any ideas? Cheers

Hi, I'm wanting to use the MS slider control to change values in a formula - is there an easy way of linking a cell in excel to the control to get this? Cheers

Hi, Does anybody know of a way to set up Excel (and Word) so that whenever you open a new document it automatically sets up a footer with the path name on? I can get it to do this in Excel when you start up excel by saving the correct .xlt in the program folder however I can't get it to do...

Hi, I'm trying to manage some external links I have through to a Dimensions Access database (our accounting software). Normally I would manage this via the Add-Ins tab but it's disappeared! I've followed some online help that suggested it would automatically appear when a not standard excel...

Hi, I'm trying to use the INDIRECT function on a summary worksheet to refer to values on other worksheets that are named after the months of the year. I have to have the year in as well as the month as the summary sheet covers 5 years. I can get the formula to work no problems in the data...

Hi, Not strictly an access question but hoping someone with VBA skills can help out. I've hundreds of emails, from the same person, all with attachments. Is there a VBA script I can run that will look at these emails and download the attachment to a specified area on my drive - without me...

Hi, Does anyone know of a quick way of counting the number of digits within a given cell ref? Cheers

Hi, I've just upgraded to 2007 and I also use Access Accounts (Not MS Access) with the Access Office Integration (AOI) version 3.02. I have added the Add In so I can link to the Access Db and draw info through via an ODBC. Whilst the initial links are working it won't allow me to create any...

Hi, I get this every few years can keep forgetting how to get out of it but I have a spreadsheet where the one cell remains highlighted and is locked to that cell, so even if I select another cell it stays locked to it - any ideas? Cheers

Hi, I have a combo box where it is linked to a list of dates so that these can be chosen. However it displays the date in the Julian format rather than dd/mm/yyyy that I want. The source list is in this format and I can't work out how to change the format in the combo box - can someone point...

Hi, Is there a quick and easy way of having text change colour when the pointer is over it, in excel? Cheers

Hi, I want format some cells based on the contents of another cell. For Example if A1 is True then I want cells A2:A10 to be coloured orange. I can't seem to work it out using the standard Conditional Formatting option - is it me?! Cheers

Hi, I want to be able to have a formula that sums a range of cells where by the starting point is known but the end point is variable number of columns to the left of the starting point. The variable number is a function of the number of days between today and the start of the month. This...

Hi, does anyone know if it's possible to link an excel workbook to a visio file so that any numbers changing within excel with update in visio? Got a presentation that keeps changing and I'm having to manually update a load of numbers! Cheers

hi, I have lines of data that is made up of a reference number (7 digits) and names. I want to be able to extract just the reference number from the string. The reference number is sometimes at the front, in the middle or at the end - which I have no control over. Does anyone know of a way...

Hi, I have a set of tables for different locations (5 in total) and 1 for each month. They are all called location.month, I want to be able to run a query that takes the month as the parameter and then runs a simple select and group query on the table matching that month. Can anyone help...

Hi, I have some address data in a field that contains carriage return and line feed characters. I want to be able to replace these with comma's so I can export to excel and delimit via comma to seperate the address lines. Can anyone help? Cheers

Hi, I have a table that has, amongst others, a list of order numbers. Each order number may be duplicated many times and I want to be able to use a function like countif, in excel, to update another field with the number of times that order nubmer occurs. Does anyone know of a quick way of...

Hi, I get emailed some sales data on a daily basis, in CSV format, which I then drop into an access db and run some queries to produce a report. Is there a way I can have a script that will run on a scheduled basis to either pick up the files and move them to a server, for access to pick...

Hi, I want to be able to have a spreadsheet that has multiple worksheets on, and then have a summary sheet that has tick boxes relating to the names of the worksheets. I then want to be able to have a macro that will print out the relevant worksheets that have the tick box as true - is this...