When the user hits the 'other' option in my drop down box, I would like the data validation to be reset to any value or a pop-up is displayed that allows...

I'm trying to vertically align the text in my combo boxes so that when the user selects from the list, the selection sits in the centre of the box. At the...

Hi, I have an Excel worksheet that performs certain functions such as filtering, etc based on criteria selected from drop down lists in a pop up userform....

I am having trouble with 'COUNTIF'. If I have the criteria as a single cell reference all is well. If I enter "" or "" either alone or as a range I get 0...

I have a list of about eight people who do voluntary work, Every three months they are reimbursed for activities. I have a spreadsheet with a record of these...

I have a spreadsheet with names in column A and dates along row 4. I now realise that the maximum number of names I will have will be 100 to 150 but over say...

How can I set myself as a "Trusted source". I am helping an organisation streamline there spreadsheet activities, this includes some macros. When I try to...

I have a table of people and their activities. I have no trouble adding new people but have a problem on deletion. If I delete a row there is the problem of...

I have range say c150:x200. Row 150 contains names, and the lower rows, data. How do I delete the columns in the range without data (deleting also the name)....

I apologise for posting this here but I don't know where to post it, and there are lots of knowledgeable people out there. I have a problem with my keyboard....

Hello I just need some help with a small macro. I need it to find any values in a sheet that have the value "#N/A N/A". The macro then need to copy down the...

When I have many workbooks open (20+) the vertical tiling on the taskbar at the bottom doesn't work properly in that when you select the workbook you want it...

Is there a small macro that will take all the worksheets from all open workbooks and put them in one new consolidated workbook? Thanks Barry

I have recently moved from Excel 2002 to 2007 and when saving a large file with several macros and reopening it keeps saying that there is unreadable content...

can i ask is there a command button wizard to e.g. add a macro to a command button in excel 2003, if so can i add a macro to change autofilter values, the...

any advice on some strange behavior i'm seeing in xl 2003?? - when i open a file that has previously been filtered it initially blinks up thye filtered view...

Hi All, I have a list of values sorted in ascending order with an accompanying ID(name) for each value in the adjacent column e.g. 3 D 5 K 6 Z 7 J 8 S 10...

In Excel 2002 (Windows XP Pro OS), is there a way to have the Import External Data path default to the last folder visited (the way it did in Excel 97), rather...

I have a spreadsheet containing various columns of data A B C D E F etc. Agr no. Amount N/A N/A ...

I would like zero values at the start of a number eg. 0015624 that drops into a cell using a formula. I know that if I type '0015624 then the first two...