Search results

Sounds as though you need a Pivot Table. Unfortunately my knoweledge of Pivot Tables ends with there use. I have yet to create one myself but believe that this would be your best option. Matt

I have a spread sheet that I have hijacked from a 3rd Party. I've disabled the Marco's written by someone else as I do not need them (they are also secure). I am able to Hide rows and columns but without ASAP Utilities I cannot Unhide any. I understand that none of us can view any VBA as it is...

AnnPhil Can I ask what you are using the interaction between AutoCad and Excel. I am interesed as I am looking to, through the "filter" comand of CAD to import the number found directly into a worksheet for take off purposes and wonder what you are using it for. I am very new to CAD but see a...

I use the copy and paste method and also ensure that the range (assuming you are doing this) I am sure that its a case of right click on the combobox and paste elsewhere. The combobox automatically asigns a new name in numerical order. Hope this helps, Matt

Brilliant Thank you for your help as always it ends up being easier to solve than I thought, although I still don't think that I would have got it. Thanks again. Matt

I have attached a file that I hope better explains what I would like to acheive. The user enters a from & to date and the cell in the adjacent range fills automatically. I am assuming that the easiest way is through conditional formatting but I cannot work out the formula and would be grateful...

Thanks for your help. I was hopping for something a little sexier though but understand that the simplist solutions are usually the best. Regards, Matt

Is anyone able to tell me if and if so how to lock a worksheet Tab so that it is always visible when scrolling through all the tabs. I have an add-in that can create an index sheet but I really need to keep 1 tab visable at all times. Regards, Matt

I will give it a whirl. Thanks, Matt

Thank you Minkey The source is trusted however I have tried to save target and all those options that are open when you right click. please find attached the View Source Code:- Thanks Matt

I have been sent an email and on the review pane is an annimation. Is there anyway to extract this annimation to save it and use it in other applications such as screen savers, in word docs etc. Thanks, Matt

s Not sure what you mean so I have attached a file that at least is a start. Matt

Thank you Shades I have tried to modify your code, but I am unfortunately not that clever and have not succeded. I have attached my file. The file is for checking lottery results via a user form. I trust the workbook is self explainatory and hope that you will be able to assist further...

Dear All I have a range (“numbers”) with 95 cells all containing a value (some the same) I have a range (“results”) with 5 cells all containing user defined values (non the same) What I would like I have a CommandButton3 that when clicked on UserForm1 I would like any values in range...

Thank you Regards, Matt

This is a very helpfull thread, but can anyone tell me where I can locate the colour code's ie 6=yellow. Where can I find a list of the other codes? Regards, Matt I have tried putting the following into Conditional Formating =ASAPCellColorIndex(A2)=6 and then set the condition from it, I am...

Richard Please find attached ZIP Hope this helps. Regards, Matt

cymrudesign Please see attached. You have the right code it just needs to be placed in workbook window. see attached file. Regards, Matt

cymrudesign I have attached a file that contains your code but has an addtional ComandButton that once clicked increases the number in Range A1 by one. It would appear that the Private Sub Workbook_Open() Is not the correct method for actionaing the auto increment you require. I am sure...

This is really a three fold question. When openning an Excel file that is already opened by another user it is only possible to view as read only where no changes can be made. 01 - Is it possible to find out (without walking round the office) the user name of the individual that has it open...