Hi all, I am having difficulty with the VBA code for a command button on a form. All I need it to do on click is open another form. Any help is great! Thanks,...

Is it possible to add more than 3 conditional formats to a particular cell? Any help would be much appreciated. Thanks, -A ---

Pivot experts, I prepared a pivot table with several different summing data fields. If I view(filter) the pivot table with less than all the data fields, the...

I am trying to open a shared file on a network and Excel stops responding. Can anyone shed light on this? Thank you.

I have created an questionnaire in Excel, where the respondents fill in the amounts to questions and select different options. This questionniare is going to...

I am trying to see if I can create a frequency function that will change as I autofilter different criteria. I have a file with over 15,000 rows returning...

I have 30 sheets in a workbook, and I want cell V43 in each worksheet to have the named range Page_Num. If I had one sheet with this range name, then copied...

Does someone know of VBA code that will bring up a "find" type of dialogue box that when the user types in the data, the data is searched for and if found, the...

I have multiple databases in Excel with similar data that I need to pull into one large database. The only way I know to combine the information is cut...

Excel XP had an add-in "AccessLinks", which allowed the export of worksheet information to an Access table. This does not appear to be available in 2003. Is...

Hello, I have a rows of data in which I want to get, for each row, the position (not the value) of the first and last non-blank cell in the row. Basically...

Hi, I am trying to run a letter to our membership by group, but listing all members from that group on the letter. I've written the letter in Word and done...

In Office XP I used the Access Links add in for Excel to export spreadsheet information into a database. I could not do this by importing into Access...

Hi, I am wanting to get a formula where if I type 1 - 99 I should get A =100 or 199 I should get B =200 or 299 I should get C =300 or 399 I should get...

Hi. I have a pivot table that combines data from many workbooks. One column contains varying lengths of text, so automatically resizes to much wider than...

I've just come across something which is concerning me a little. I have a large table of data, comparable to a list of customer orders. The first column...

Hi. Is there a way to enter a TRULY null value in a cell? I intend for the formula below to leave the cell blank if the criteria is met. My problem is that...

I was keying in some information in excel and all of them begins with http://www.... It kind of irritates me when I am always clicking onto the information and...

Is there a feature of Excel or a macro that I could write to disable 'save' (both the icon and the drop down option)?

cannot open completed worksheet from folder that is in My documents. Cannot do anything with it.